SQLSERVER 简单的游标使用

declare @id int
declare @name nvarchar(100)
--声明游标c_department
declare c_department cursor for
  select id,name from department
--1、打开游标
open c_department
--2、提取数据
fetch next from c_department into @id,@name
while @@FETCH_STATUS=0
begin --3、数据操作
  --代码
  --代码
  fetch next from c_department into  @id,@name
end
close c_department--4、关闭游标
deallocate c_department--5、删除游标