sql sever不能用create table table1 as select * from table2

sql sever不能用create table table1 as select * from table2；

这是oracle中这样用，sql sever用例如：select *

                                                              into Student_backup from Student;