游標的使用

 

declare @userid varchar(20)

-- 將 temp2 值賦給當前游標

declare c_getdata cursor for

select userid from temp2

-- 打開當前游標 , 并將游標值賦給變量

open c_getdata

    fetch c_getdata into @userid

    while(@@fetch_status = 0 )

        begin

            -- 當前游標與數據庫中 temp 表結合

            -- 將結果導入結果數據庫 sysuserdept 表中

            insert into sysuserdept(userid,deptid)

            select @userid,deptid from temp

            -- 循環變量值更新

            set @userid = null

            fetch c_getdata into @userid

        end

close c_getdata

deallocate c_getdata