declare @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