How to create a table from select query result in SQL Server 2008

Question

I need to create a table from select query result in the SQL Server, I have tried.

create table temp AS select.....

However, I am getting the error.

Incorrect syntax near the keyword 'AS'

Answer 1

You can use the following syntax to create a new table from the old table in the SQL server 2008.

Select * into new_table  from  old_table 

 Want to become a SQL Expertise? Register to this SQL Course and get certified.