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
原文：http://www.cnblogs.com/wanghonghu/p/5592478.html