insert newtable( filed1,filed2...) select filed1,filed2... from oldtable where 条件
IF EXISTS (SELECT name FROM tempdb.dbo.sysobjects WHERE name = 'newtable' AND type = 'U') insert newtable select filed1,filed2... from oldtable where 条件 ELSE select filed1,filed2... into newtable from oldtable where 条件
insert newtable select filed1,filed2... from oldtable where 条件
ELSE select filed1,filed2... into newtable from oldtable where 条件