一个简单的SqlServer游标使用
时间：2021-07-01 10:21:17
帮助过：2人阅读
@id int
declare @name nvarchar(
100)
declare c_department
cursor for
select id,name
from department
open c_department
fetch next from c_department
into @id,
@name
while @@FETCH_STATUS=0
begin
--代码
--代码
fetch next from c_department
into @id,
@name
end
close c_department
deallocate c_department
一个简单的SqlServer游标使用
标签：
