T-SQL: How can you create a table with SELECT?

user_4782 0
Viewed 70338

In oracle, you can issue:

 create table foo as select * from bar;

What is the equivalent T-SQL statement?

oracle tsql
3 Answers

You can use SELECT INTO. From MSDN:

The SELECT INTO statement creates a new table and populates it with the result set of the SELECT statement. SELECT INTO can be used to combine data from several tables or views into one table. It can also be used to create a new table that contains data selected from a linked server.

So:

SELECT col1, col2, col3 INTO newTable FROM existingTable;
Oded_15830

You can try like this:

select * into foo from bar
user_547460

If you want to write to the tempdb

Select *
INTO #tmp
From bar

or to a SQL DB

Select *
INTO Temp
From bar
user_1922040
Related