星期一, 十月 18, 2010

MSSQL 模仿 ROWID 功能

select * from (select *, ROW_NUMBER() OVER (ORDER BY batch_id ASC) AS ROWID from SalesOrder ) as ma where ma.rowid > 1000