请问如何取出由游标指定的那一行呢?如下
declare @a as char(16)
declare myCursor CURSOR for
select top 10 lotid from lot

open myCursor

FETCH next FROM myCursor
CLOSE myCursor
DEALLOCATE myCursor
上面中取出来第一行的lotid
如何付给一个变量呢
select top 10 @a=lotid from lot不成立

thanks

[解决办法]
declare @a as char(16)
declare myCursor CURSOR for
select top 10 lotid from lot

open myCursor

FETCH next FROM myCursor into @变量名
CLOSE myCursor
DEALLOCATE myCursor