编写tsql,如何获取查询的结果?

[bbinw]

初学mssql,有个tsql的问题求教各位:

使用以下语句进行查询
select sum(aaa1),sum(aaa2) from book where bbb = '条件'

接着要在表table1中插入一条记录,对a1,a2分别赋值查询到的结果
INSERT INTO [xx].[dbo].[table1]
( [a1],[a2])

VALUES
(???????)

以上问号部分要如何写呢?
也就是如何取得sum(aaa1),sum(aaa2)的值并将他们写入表中?

[懒牛科技]

select sum(aaa1),sum(aaa2) into [xx].[dbo].[table1] 
from book where bbb = '条件' 

[hery2002]

INSERT INTO [xx].[dbo].[table1] 
select sum(aaa1),sum(aaa2) from book where bbb = '条件' 

[懒牛科技]

如果想指定列的话可以这样
insert into [xx].[dbo].[table1] (col1,col2)
select sum(aaa1),sum(aaa2) 
from book where bbb = '条件' 

[bbinw]

多谢mqcan,顺便问问如果是要将sum(aaa1)先赋值到变量@aaa,然后再插入到表中,要如何写呢?

@aaa=????
INSERT INTO [xx].[dbo].[record]
( [aaa1])

VALUES
(????)

[octwind]

[Quote=引用 4 楼 bbinw 的回复:]
多谢mqcan,顺便问问如果是要将sum(aaa1)先赋值到变量@aaa,然后再插入到表中,要如何写呢?

@aaa=????
INSERT INTO [xx].[dbo].[record]
( [aaa1])

VALUES
(????)
[/Quote]
select @aaa=sum(aaa1)
from book where bbb = '条件'
INSERT INTO [xx].[dbo].[record]
([aaa1]) VALUES (@aaa)

[正宗老冉]

[Quote=引用 4 楼 bbinw 的回复:]
多谢mqcan,顺便问问如果是要将sum(aaa1)先赋值到变量@aaa,然后再插入到表中,要如何写呢?

@aaa=????
INSERT INTO [xx].[dbo].[record]
( [aaa1])

VALUES
(????)
[/Quote]

INSERT INTO [xx].[dbo].[record] ( [aaa1]) 
SELECT SUM([aaa1]) FROM [xx].[dbo].[record]