SQL 游标根本用法

SQL 游标基本用法

CREATE PROCEDURE [dbo].[pro_CURSOR]ASBEGIN--声明一个游标DECLARE MyCURSOR CURSOR FOR SELECT userid,depid FROM users--打开游标open MyCURSOR--声明两个变量declare @userid varchar(50)declare @depid varchar(50)--循环移动fetch next from MyCURSOR into @userid,@depidwhile(@@fetch_status=0)  begin    update users set description=(select dep_des from department where depid=@depid)where userid=@userid    fetch next from MyCURSOR into @userid,@depid  endclose MyCURSORdeallocate MyCURSOREND

?