如题。
declare @table table(id int,Name char(50))
insert @table values(12,'aaaaaaaaaaa')
insert @table values(5362,'bbbbbbbbbbbb')
insert @table values(333,'eeeeeeeee')
insert @table values(444,'tqqqqqqqqqqqq')
with aaa as(
select * from @table
)
select * from aaa
select count(1) from aaaaaa 如何才能多次使用?
declare @table table(id int,Name char(50))
insert @table values(12,'aaaaaaaaaaa')
insert @table values(5362,'bbbbbbbbbbbb')
insert @table values(333,'eeeeeeeee')
insert @table values(444,'tqqqqqqqqqqqq')
with aaa as(
select * from @table
)
select * from aaa
select count(1) from aaaaaa 如何才能多次使用?
解决方案 »
- sp_send_dbmail发邮件不能跨域问题,请各位指导!TKS!
- 索引问题
- 20071206141114这种VARCHAR的如何转换成日期型的2007-12-06 14:14:14
- 请教一下与数据库中数据类型有关的问题,谢谢
- 求解:sql查询问题!!
- SQLServer 2005还原时要独占访问权的问题
- 通过动态建立一个储存过程表,如何能在ASP中通过查询列数及列名后,在通过列名查询其列名下的内容。。。(
- 有个奇怪的阻塞现象,想请教大家?
- 将表从2005转到2000后,怎么标识键没了?
- 如何制作 具有剪切、复制、粘贴、撤消、重做、等功能的菜单?
- 帮个忙,sql server 2000端口打不开
- 请教一条SQLSER2000下的一条语句,求某一日期前后的数据。
select * into #tb from @table
USE AdventureWorks;
GO
WITH DirReps(ManagerID, DirectReports) AS
(
SELECT ManagerID, COUNT(*)
FROM HumanResources.Employee AS e
WHERE ManagerID IS NOT NULL
GROUP BY ManagerID
)
SELECT ManagerID, DirectReports
FROM DirReps
ORDER BY ManagerID;
GO
生成臨時表,或用表變量存儲,CTE不可生成多個結果集
只能想办法写在一个CTE的语法中,然后处理这个数据集合
insert @table values(12,'aaaaaaaaaaa')
insert @table values(5362,'bbbbbbbbbbbb')
insert @table values(333,'eeeeeeeee')
insert @table values(444,'tqqqqqqqqqqqq')
;WITH aa(id, name) AS
(
SELECT ID,name
FROM @table
)
SELECT *,count=(select COUNT(1) from aa)
FROM aa