create table as

[wo_happy]

请大侠指点指点，是不是不能这样create table呀，那要是我想用一个查询的结果create a table,我该怎么办呢？
create table aaa
as select * from bbb;

[SQL77]

select * INTO AAA from bbb;

[--小F--]

[Quote=引用 1 楼 sql77 的回复:]
SQL code
select * INTO AAA from bbb;
[/Quote]
up

[东那个升]

CREATE TABLE TB1(I INT)

INSERT TB1 SELECT 1

SELECT * INTO TB2 FROM TB1

SELECT * FROM TB2

I
-----------
1

(1 行受影响)

[喜-喜]

select * INTO AAA from bbb;

[sql_sf]

[Quote=引用 5 楼 ncufunk 的回复:]
create table aaa
as select * from bbb;


这个是在oracle 上的写法
mssql 要使用select * into table_name from table1
[/Quote]
UP

[wo_happy]

谢谢各位大侠指点!!!

[ShenLiang2025]

Hi

0)See structure of TestTmp

SELECT * FROM TestTmp WHERE 1 = 3

test
--------------------

(0 row(s) affected)

1)Copy column(s) from TestTmp without data involved to new table AAA

SELECT * INTO AAA FROM TestTmp WHERE 1 = 3 -- 1 = 1

2)Test AAA's structure

SELECT * FROM AAA WHERE 1 = 3

test
--------------------

(0 row(s) affected)

[ncufunk]

create table aaa
as select * from bbb;


这个是在oracle 上的写法
mssql 要使用select * into table_name from table1