Use following syntax to create new table from old table in SQL server 2008
Select * into new_table from old_table
2.1m questions
2.1m answers
60 comments
57.0k users