得到行号 rowid 的方法
[ 2006-05-16 21:55:44 | 作者: admin ]
方法一（采用临时表，2005版本之前）
数据量的时候非常慢
方法二 2005支持row_number()
row_number()在2005中被支持：
评论Feed: http://blog.xg98.com/feed.asp?q=comment&id=608
数据量的时候非常慢
if object_id('tempdb..#') is not null drop table #
go
select identity(int, 1, 1) as id, * into # from test
select * from #
drop table #
go
select identity(int, 1, 1) as id, * into # from test
select * from #
drop table #
方法二 2005支持row_number()
row_number()在2005中被支持：
USE AdventureWorks;
GO
WITH OrderedOrders AS
(SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader )
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60;
GO
WITH OrderedOrders AS
(SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (order by OrderDate)as RowNumber
FROM Sales.SalesOrderHeader )
SELECT *
FROM OrderedOrders
WHERE RowNumber between 50 and 60;
[最后修改由 admin， 于 2006-05-16 22:23:27]
评论Feed: http://blog.xg98.com/feed.asp?q=comment&id=608
这篇日志没有评论。
此日志不可发表评论。
