insert into result (a,b,c)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)
解决方案 »
- 这两张表如何用视图的方式实现
- SQL 单步调试时出错
- sql2005中如何用bcp? bcp vrdn.. recinsurance out c:\testlog.txt -c -t"|" -U startmaintuser -P start14 -S tfistrdv001 -b 50
- 求唯一列的SQL语句
- 变态的项目,变态的难题!
- CSDN求得的一SQL语句 经测试还有一些问题 请各路高人帮忙 在线等
- 实现可以任意修改关联表数据的级联更新操作 (答案详细者给50分、举例说明给20分)
- 关于text类型大小的一个问题!!!
- 做过财务的朋友,能留下QQ吗?以方便我请教!
- 急!高手请帮忙,如果解决我的分全给了(400)
- == 初学者问,怎样移植一个 SQL 数据库?==
- 模式匹配的简单问题
(select
(select count(*) from data1) as a,
(select count(*) from data2) as b,
(select count(*) from data3) as c)
declare @b intselect @a=count(*) from data1
select @b=count(*) from data2insert into result(a,b) values(@a,@b)
select (select count(*) from data1),
(select count(*) from data2),
(select count(*) from data3)