SQL 游标基本用法

CREATE   PROCEDURE   [ dbo ] . [ pro_CURSOR ]
AS
BEGIN

-- 声明一个游标
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 , @depid
while ( @@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
end

close  MyCURSOR
deallocate  MyCURSOR

END