--参考
use northwind
go
declare @number integer
set @number=4
exec('select top '+@number +'* from orders order by orderid')
use northwind
go
declare @number integer
set @number=4
exec('select top '+@number +'* from orders order by orderid')
调试欢乐多
as
begin
Exec('select top '+ @number + '* from student order by score')
end
as
begin
exec('select top '+@number+' * from student order by score')
end
as
begin
set rowcount @number
select * from student order by score
end
DECLARE @n AS BIGINT
SET @n = 5
SELECT TOP (@n) *
FROM SalesOrderHeader AS SOH
ORDER BY OrderDate, SalesOrderID SalesOrderID 用作附加键。类似的,以下示例说明了如何使用 PERCENT 选项按所请求百分比返回最早定单:DECLARE @p AS FLOAT
SET @p = 0.01
SELECT TOP (@p) PERCENT *
FROM SalesOrderHeader AS SOH
ORDER BY OrderDate, SalesOrderID---shit!难到我要等到Yukon出来?有谁可以告诉我 set rowcount N
select ....
set rowcount 0是否等价于 select top N ... ?
我觉得set rowcount 不好之处是影响了子查询的行数,所以在用到rowcount时,一定不能嵌套子查询,除非rowcount设得足够大。