sql 2005可以把query入面的ｄａｔａ來create 一個ｔａｂｌｅ嗎

簡單地說, 由 query 建立一個 table 的 sql 語法是:

CREATE TABLE table_name AS ( your_work_query_here );

例子:
CREATE TABLE new_table AS (SELECT * FROM old_table);
CREATE TABLE suppliers AS (SELECT * FROM companies WHERE id > 1000);
CREATE TABLE new_table AS (SELECT column_1, column2, ... column_n FROM old_table);

-------------------------------------------------------

刪除 table 的 sql 語法是:

DROP TABLE table_name;

例子:
DROP TABLE supplier;

-------------------------------------------------------

我的名字is raymond li
我有網站可以賺錢和創業。
www.money128.biz和www.fast - beauty.6289.us
我還有美容產品可以免費試用詳情
請發送電子郵件給我。
[email protected]
感謝你。

I have never seen this syntax

CREATE TABLE TABLE_1 AS (SELECT * FROM QUERY_1)

When executed, SQL Server 2005 gives this error
The CREATE TABLE SQL construct or statement is not supported.

The correct syntax is

SELECT * INTO New_Table FROM My_Table
SELECT Column_1, Column_2 INTO New_Table FROM My_Table WHERE Column_1 > 100

To delete a table

DROP TABLE My_Table

2007-10-05 03:09:35 補充：
This syntax does not work in SQL Server 2005. It works in mySQL and Postgre SQL only.

蛙王郭孟浩