sql 游标

declare @id int

declare @name nvarchar(100)

declare cur cursor
for select id,name from JLCheckDocumentBill where id in (1,2,3)
open cur
fetch next from cur into @id ,@name
while @@fetch_status=0
BEGIN



fetch next from cur into @id,@name
END
close cur
deallocate cur

原文：http://www.cnblogs.com/YyuTtian/p/4443920.html