use carddb
DECLARE @info varchar(200)
declare @sum varchar(8000)
DECLARE @curs cursor
set @sum=''
SET @curs=cursor scroll dynamic
FOR
select TOP 6 r.OuterUID+':'+cast(re.ChannelID as varchar(50))+';' as info from BankCard_PayUsedRecord r(nolock)
join BankCard_PayUsedRequest re(nolock) on r.RecordId=re.RecordId
OPEN @curs
FETCH NEXT FROM @curs INTO @info
WHILE (@@fetch_status=0 )
BEGIN
select @sum = @sum + @info+';'
print @sum
--SELECT @info =@info+';'
FETCH NEXT FROM @curs INTO @info
END
print @sum
CLOSE @curs
deallocate @curs
原来sql里的变量要赋值再应用,否则为空