declare @s varchar(8000) set @s=''select @s=@s+col from tb where 条件print @s
create table #t(f1 varchar(100))insert into #t select 'A' insert into #t select 'B'declare @s varchar(8000)set @s=''select @s=@s+f1 from #tselect @sdrop table #t
declare @t table (a varchar(10)) insert into @t select 'a' union all select 'b'decalre @str varchar(8000) set @str ='' select @str = @str + rtrim(a) from @t select @str
set @s=''select @s=@s+col from tb where 条件print @s
insert into #t select 'B'declare @s varchar(8000)set @s=''select @s=@s+f1 from #tselect @sdrop table #t
insert into @t
select 'a' union all
select 'b'decalre @str varchar(8000)
set @str =''
select @str = @str + rtrim(a) from @t
select @str