select * into test_01 from sec0908_test_numbers这样不行么?
---这样创建表语法是不对的。 select * into test_01 from 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;
select * into test_01
from 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;