Create table command with data

[DanAuber]

In Oracle you can run an SQL command:

Create table table_name as (select column_1 from source_table);

Thus both creating a table and putting data into it in one hit.

Is this possible in SQLSERVER ? - what would the syntax be ??

thanks for any help

Dan Auber

 

[LFCfan]

Hi,

The syntax you're looking for is SELECT INTO:

SELECT * INTO NewTable FROM OldTable

HTH