【Sql Server】创建游标

最新推荐文章于 2024-08-30 14:11:18 发布

呼噜噜哟

最新推荐文章于 2024-08-30 14:11:18 发布

阅读量921

点赞数

分类专栏：【003】数据库

本文链接：https://blog.csdn.net/u011176794/article/details/52610498

版权

【003】数据库专栏收录该内容

9 篇文章 0 订阅

订阅专栏

 --定义变量
 declare @StudentName  varchar(100)
 --定义游标
 declare UpdateTeacherName Cursor for  select StudentName from StudentInfo   
 --打开游标
open UpdateTeacherName
--遍历游标，且将获取的数据赋值到定义的变量中
fetch next from UpdateTeacherName into @StudentName

while @@Fetch_Status =0

begin
--具体要做的事情
if @StudentName = 'zhangSan'  update StudentInfo set TeacherName ='李老师' where studentname = 'zhangSan'
   
if @StudentName = 'WangWu'  update StudentInfo set TeacherName ='王老师' where studentname = 'WangWu'

if @StudentName = 'LiSi'  update StudentInfo set TeacherName ='赵老师' where studentname = 'LiSi'

if @StudentName = 'ZhaoLiu'  update StudentInfo set TeacherName ='范老师' where studentname = 'ZhaoLiu'
--再次遍历游标，这句话一定不能忘记
fetch next from UpdateTeacherName into  @StudentName

end
--关闭游标
close UpdateTeacherName
--删除游标
deallocate UpdateTeacherName