declare @a varchar(8000),@b varchar(8000)
set @a=''
select @a=@a+name+',' from syscolumns where id=object_id('目标表') and name<>'你不要的列名'
select @a=@a+name+',' from syscolumns where id=object_id('源表') and name<>'你不要的列名'
select @a=left(@a,len(@a)-1),@b=left(@b,len(@b)-1)