摘要: declare @t1 datetime,@total intset @t1=GETDATE()select rowId,BuildName from (select top 2896 row_number() over( order by id asc) rowId,BuildName from tbl_data_House order by id asc) tb where tb.rowId>10 and tb.rowId10 and tb.rowId10 and tb.rowId10 and tb.rowId<=20print datediff(ms,@t1,getdate( 阅读全文
posted @ 2014-02-24 16:14 一千零一夜 阅读(485) 评论(0) 推荐(0) 编辑