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'
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.