sql语句使用游标修改表中数据

declare @a varchar(100),@b varchar(100)
declare user_cursor cursor for
select a,b from tableA tab 
open user_cursor
fetch next from user_cursor
into @a,@b
while @@fetch_status=0
begin
update tableA set a=@a where b=@b
fetch next from user_cursor
into @a,@b
end 
CLOSE user_cursor
DEALLOCATE user_cursor

 

/*游标的使用*/

--定以后直接赋值--
declare test_Cursor Cursor GLOBAL for/*全局游标*/
select*from dbo.tab1

--先定义后赋值--
declare @test_Cursor2 cursor LOCAL for/*局部游标*/
set @test_Cursor2=Cursor for
select*from dbo.tb2

--用GO结束上面的作用域--
go
open text_Cursor
open text_Cursor2

 

转载于:https://www.cnblogs.com/ly77461/p/5736473.html