尝试:

SELECT TOP 1 id, aaa, bb, cc FROM myTable WHERE id > @id ORDER BY id ASC

您可以使用

<您的序列名>
的下一个值
检查此链接，
http://msdn.microsoft.com/en-us/library/ff878058.aspx [ ^ ]
希望这会有所帮助.

Hi,

You can use ,

NEXT VALUE FOR <your_sequence_name>

check this link,
http://msdn.microsoft.com/en-us/library/ff878058.aspx[^]
Hope this helps.