sql - 如何从SQL Server 2008中的选择查询结果创建表[重复](How to create a table from select query result in SQL Server 2008 [duplicate])

Question

This question already has an answer here:

(这个问题在这里已有答案：)

• How to create table using select query in SQL Server?

  (如何在SQL Server中使用select查询创建表？)

  3 answers

  (3个答案)

I want to create a table from select query result in SQL Server, I tried

(我想在SQL Server中从select查询结果创建一个表，我试过了)

create table temp AS select.....

but I got an error

(但是我收到了一个错误)

Incorrect syntax near the keyword 'AS'

(关键字“AS”附近的语法不正确)

  ask by yogesh9239 translate from so

Answer 1

使用以下语法从SQL Server 2008中的旧表创建新表

Select * into new_table  from  old_table