62,242
社区成员




create table ## (id varchar(10))
declare @sql1 varchar(8000),@sql2 varchar(8000),@sql3 varchar(8000)
select @sql1='select '+replace('1,2,3',',',' as id union all select ')
select @sql2='select '+replace('1,2,4',',',' as id union all select ')
exec('insert into ## select distinct id from ('+@sql1+' union '+@sql2+')tp')
declare @sql3 varchar(8000)
select @sql3=isnull(@sql3+',','')+id from ##
select @sql3 as '结果'