四种sql server 数据库分页的测试
摘要：
SET statistics io onSET STATISTICS TIME ONGOView Code ----1PRINT'fistbegin'DECLARE@timeDATETIMEDECLARE@msintSET@time=GETDATE()SELECT*FROMClient.clientAScINNERJOIN(SELECTRowNum,ClientIDFROM(SELECTROW_NUMBER()OVER(ORDERbyClientIDASC)ASRowNum,ClientIDFROMclient.client)ASccWHEREcc.RowNumbetween1 阅读全文
posted @ 2011-07-22 11:41 青春的虎子 阅读(573) 评论(1) 推荐(0) 编辑
