以下是相关部分语句:declare @idx int declare @Ret_Nbr varchar(2100) declare @Ret_Id varchar(1000) declare @mv_Nbr char(21) declare @mv_Id char(10).......set @idx=0 set @Ret_Nbr='' set @Ret_Id='' open #mm1 ----我定义的cursor fetch next from #mm1 into @mv_Nbr,@mv_Id while @@fetch_status=0 begin if(@idx<100) begin set @Ret_Nbr=@Ret_Nbr+isnull(@mv_Nbr,'') set @Ret_Id=@Ret_Id+isnull(@mv_Id,'') end set @idx=@idx+1 fetch next from #mm1 into @mv_Nbr,@mv_Id end......
declare @str varchar(8000)
declare @Ret_Nbr varchar(2100)
declare @Ret_Id varchar(1000)
declare @mv_Nbr char(21)
declare @mv_Id char(10).......set @idx=0
set @Ret_Nbr=''
set @Ret_Id=''
open #mm1 ----我定义的cursor
fetch next from #mm1 into @mv_Nbr,@mv_Id
while @@fetch_status=0
begin
if(@idx<100)
begin
set @Ret_Nbr=@Ret_Nbr+isnull(@mv_Nbr,'')
set @Ret_Id=@Ret_Id+isnull(@mv_Id,'')
end
set @idx=@idx+1
fetch next from #mm1 into @mv_Nbr,@mv_Id
end......