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 [email protected])where [email protected] fetch next from MyCURSOR into @userid,@depid endclose MyCURSORdeallocate MyCURSOREND
?