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