麻烦详细说一下每条语句的意思!
declare @n as bigint;
set @n=1000000;
with Base as
(select 1 as n union all
select n+1 from Base where n<ceiling(sqrt(@n))
),
expand as
(
select 1 as c
from Base as B1,Base as B2
),
Nums as
(
select row_number() over(order by c) as n
from expand
)
select n from Nums where n<=@n
option (maxrecursion 0)
declare @n as bigint;
set @n=1000000;
with Base as
(select 1 as n union all
select n+1 from Base where n<ceiling(sqrt(@n))
),
expand as
(
select 1 as c
from Base as B1,Base as B2
),
Nums as
(
select row_number() over(order by c) as n
from expand
)
select n from Nums where n<=@n
option (maxrecursion 0)
解决方案 »
- Record表中EndTime不能早于BeginTime怎么写?
- sql语句中这样运算出错:YEAR('1725-3-4'),怎么回事?
- WIN XP下安装SQL2000做局域网的数据库服务器,有办法吗?
- 怎样完全删除原来装的mysql在uburtu上的,再重新安装呢?
- 我用的是DAO,想把指针移动到指定的记录,改如何做
- 我想知道SQL Server Management Studio这个软件有什么作用
- 如何将列转为行????详见内
- 求救,我的SQLSERVER 2000怎么不能启用了?
- 一个简单的查询,但是我不会
- 大劫难,我用的是jdbc:odbc,sql server,显示数据时,必须按字段的先后顺序取值,否则会出错“无效的描述符索引”
- c语言数据库链接
- sql触发器可以调用网站程序么?
expression_name [ ( column_name [ ,...n ] ) ]
AS
( CTE_query_definition )