将查询结果存储到另一个表中

问题描述：

SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno;

我想对此查询产生的表执行查询.

i want to perform a query on the table resulting from this query. Is it possible to to store the result in another table?

答

 Insert into TableName SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno;

试试这个

with courseIdTemp (Courceno , PaperID) as
(
SELECT     course.Courseno,ids.PaperID
FROM         course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno

)

Select * from courseIDTemp

或

SELECT     course.Courseno,ids.PaperID
into CourceIDMix
FROM   course CROSS JOIN
                      ids WHERE course.Courseno=ids.Courseno
select * from CourceIDMix

朋友，

创建临时表并移动内容

快速概述:SQL Server 2005中的临时表 [ ^ ]

问候，
~~ Karthik.J ~~

friend,

create temporary table and move the content

Quick Overview: Temporary Tables in SQL Server 2005[^]

Regards,
~~Karthik.J~~

将查询结果存储到另一个表中

相关推荐