begin
---执行一定的操作.
Set @CurTopic=''
select @CurCode=@CurCode+','+MCode from MyModule Where Topic =''+@CurTopic+''
if @CurCode<>''
Begin
print '记录一条'
set @CurCode=right(@CurCode,len(@CurCode)-1)
insert into #MyTable(MyCode) Values(@CurCode)
End
fetch MyCursor into @CurTopic
print '循环一条'+@CurTopic
--FETCH NEXT FROM MyCursor INTO @CurTopic
end
---执行一定的操作.
Set @CurTopic=''
select @CurCode=@CurCode+','+MCode from MyModule Where Topic =''+@CurTopic+''
if @CurCode<>''
Begin
print '记录一条'
set @CurCode=right(@CurCode,len(@CurCode)-1)
insert into #MyTable(MyCode) Values(@CurCode)
End
fetch MyCursor into @CurTopic
print '循环一条'+@CurTopic
--FETCH NEXT FROM MyCursor INTO @CurTopic
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货