摘要:
--方法一:sql2000/2005SELECT TOP pagesize *FROM table1WHERE id > ( SELECT ISNULL(MAX(id),0) FROM ( SELECT TOP pagesize*(pageno-1) id FROM table1 ORDER BY id ) A )ORDER BY id--方法二DECLARE @pagenum AS INT, @pagesize AS INTSE... 阅读全文
posted @ 2013-07-04 18:03
百年
阅读(173)
评论(0)
推荐(0)

浙公网安备 33010602011771号