select item_id itemid,* into #Temp from Tb_BillItem where 1=0 alter table #Temp drop column item_id select @sql= N'insert into #Temp select * from xlmis.dbo.Tb ...