34,871
社区成员




declare @sql varchar(500)
select @sql=isnull(@sql+',','insert into b select ')+name from syscolumns
where id=object_id('a') and name<>'时间戳字段'
exec(@sql)
--上面写掉了。还差一点:
declare @sql varchar(500)
select @sql=isnull(@sql+',','insert into b select ')+name from syscolumns
where id=object_id('a') and name<>'时间戳字段'
set @sql=@sql+' from a'
exec(@sql)