°ïÐÄÓÅ»¯Ò»ÏÂsql - MS-SQL Server / »ù´¡Àà

declare @sql=N'SELECT TOP '+cast(@pageSize as varchar(50))+' * from (SELECT TOP '
+cast(@pageSize*@currentpage as varchar(50))+' * from [InMail] A ORDER BY A.id DESC) B ORDER BY B.id ASC'
set @sql='SELECT from ('+@sql+') C ORDER BY C.id DESC'

ÏÈÊÇ·ÖÃæ¡£µ«ÊǺóÃæÓÖ³öÀ´ÁËÅÅÐò²»ÕýÈ·ÁË¡£
Èç

1
2
3
4
5
6
7
8
9

ÏÂÃæÊÇ×îеġ£ÒªÏÔÊÇÔÚ×îÉÏÃæ
Èç¹ûpageSize=2 currentPage=2
ÔòÒªÇóÈ¡³ö
7
6
----------
pageSize=2 currentPage=3
5
4

---

²»ºÃÒâ˼£¬±êÌâ´ò´íÁË¡£

---

ÒýÓÃ

SQL code
--> Éú³É²âÊÔÊý¾Ý±í: [InMail]
IF OBJECT_ID('[InMail]') IS NOT NULL
DROP TABLE [InMail]
GO
CREATE TABLE [InMail] ([ID] [int])
INSERT INTO [InMail]
SELECT '1' UNION ALL
SELECT '2' UNION ALL¡­¡­

ÓÐûÓпÉÒÔÓÅ»¯Ò»Ïµģ¿

---

ÎÒ¿¿£¬ÏÂÃæµÄʲôÌù×ÓŶ¡£°ÑÎÒÎÊÌⶼ¸ø¸ÇÏÂÈ¥ÁË¡£

---

ÒýÓÃ

ÎÒ¿¿£¬ÏÂÃæµÄʲôÌù×ÓŶ¡£°ÑÎÒÎÊÌⶼ¸ø¸ÇÏÂÈ¥ÁË¡£

ÄãÊÇʲô°æ±¾µÄÊý¾Ý¿â£¿

---

ÒýÓÃ

ÒýÓà 4 Â¥ jinfengyiye µÄ»Ø¸´:
ÎÒ¿¿£¬ÏÂÃæµÄʲôÌù×ÓŶ¡£°ÑÎÒÎÊÌⶼ¸ø¸ÇÏÂÈ¥ÁË¡£


ÄãÊÇʲô°æ±¾µÄÊý¾Ý¿â£¿

Õâ¸ö²»ÊÇ£¬ÎÒÊÇ˵csdnÀïµÄÌù×Ó£¬ÄÇЩXXÌù£¬°ÑÎÒµÄÌù×Ó¸ÇÏÂÈ¥ÁË¡£

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighl