T
TYZhang
Unregistered / Unconfirmed
GUEST, unregistred user!
Select * Into #T From TABLE1
ALTER TABLE #T DROP COLUMN id
insert into TABLE2 select * from #T
ALTER TABLE #T DROP COLUMN id
insert into TABLE2 select * from #T