How to create a table from select query result in SQL Server 2008 [duplicate] October 6, 2022 by Tarik Use following syntax to create new table from old table in SQL server 2008 Select * into new_table from old_table