我统计一些数据要放在一个表里，怎么写这样的SQL语句？

[bjzhanghao]

用这条语句可以得到一个数字
select count(*) from data1
我有很多条类似的语句，要把这些数字作为一条记录放在名为result的表里，但我用
insert into result (a,b,c) values (
(select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3),
)
会提示“在此上下文中不允许使用子查询。只允许使用标量表达式。”
我该怎么写呢？

[CrazyFor]

insert into result (a,b,c)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)

[psxfghost]

insert into result (a,b,c)
(select
(select count(*) from data1) as a,
(select count(*) from data2) as b,
(select count(*) from data3) as c)

[afengsunwin]

那就这样写吧：

declare @a int
declare @b int

select @a=count(*) from data1
select @b=count(*) from data2

insert into result(a,b) values(@a,@b)

[列子汤问]

用存储过程吧。

[cbzdream]

insert into result (a,b,c)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)