Question

SQL Server数据库中如何将查询的结果保存到另一个表中？

Answer 1

将查询结果放在另一张表中（table2表必须存在）insert into table2 select * from table1
查询结果直接创建一个新表存放select * into table2 FROM table1

Answer 2

SELECT TOP 10 * into newtable FROM [oldtable] Where UserID=1 Order By CreateTime Desc
上面语句可以任意修改