Explore Courses Blog Tutorials Interview Questions
0 votes
in SQL by (6.1k points)

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'

1 Answer

0 votes
by (12.7k points)

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.

Browse Categories