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