sql 游标

it2022-05-05  116

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


最新回复(0)