X-Man

 

SELECT *
FROM (select *,ROW_NUMBER() Over(order by id) as rowNum from table_info ) as myTable
where rowNum between 50 and 60;

可直接使用在SQL語法中..不一定要在T-SQL 中用..

 

 SQL Server 2005中的T-SQL增强
http://info.hustonline.net/document/doc.aspx?ID=1744

SQL Server 2005新功能-TSQL
http://play.365pop.net/InfoView/Article_80580.html

 

 

~X-Man~