sqlserver类似create table as select语法

mysql或oracle语法：
create table tablenew as select * from tableold;

sqlserver语法：
select * into tablenew from tableold;