LIMIT在T-SQL中不起作用.

LIMIT does not work in T-SQL.

您必须改为使用TOP，例如:

You have to use TOP instead, like this:

SELECT TOP(1) * FROM tableEating WHERE person='$identity';

我希望这对您有用.

正如亚伦所说，如果您不想获得任意行，还需要一个ORDER BY.

As Aaron says, you also need an ORDER BY if you don't want to get an arbitrary row.