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
转载于:https://www.cnblogs.com/YyuTtian/p/4443920.html