create table test_01 as
select *
from sec0908_test_numbers;
我这个语句怎么在sql server2008里执行怎么出错了呢？
报错说as附近有语法错误
------解决方案--------------------
- SQL code
---这样创建表语法是不对的。select * into test_01from sec0908_test_numbers;--或者创建表后，然后将sec0908_test_numbers中的数据插入到此表就可以了create table test_01(id int not null identity by(1,1), ,.....)insert into test_01 select * from sec0908_test_numbers;