CREATE PROCEDURE [dbo].[pro_CURSOR]

AS

BEGIN



--聲明一個(gè)游標(biāo)

DECLARE MyCURSOR CURSOR FOR 

SELECT userid,depid FROM users



--打開(kāi)游標(biāo)

open MyCURSOR



--聲明兩個(gè)變量

declare @userid varchar(50)

declare @depid varchar(50)



--循環(huán)移動(dòng)

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