Sql 存储过程加游标结合的使用

CREATE proc jiagongzi
as
declare @name nvarchar(20)
declare @xueli nvarchar(20)
declare @time datetime
declare @gongzi intdeclare zengjia cursor scroll     
for
select * from 职员表
open zengjia
fetch next from zengjia into @name,@xueli,@time,@gongzi
while @@FETCH_STATUS=0
begin
 if (@xueli='本科' or @xueli='硕士') and DATEDIFF(year, @time, getdate())>=3
 begin
  update 职员表 set 工资=@gongzi+@gongzi*0.1 where 姓名=@name
 end
 if (@xueli<>'本科' and @xueli<>'硕士') and DATEDIFF(year, @time, getdate())>=10
 begin
  update 职员表 set 工资=@gongzi+@gongzi*0.08 where 姓名=@name
 end
 fetch next from zengjia into @name,@xueli,@time,@gongzi
end
close zengjia       
deallocate zengjia  goexec jiagongzi