一个取数据集中指定一段记录的简单方法

　　首先定义一个数据表，以备后面使用。定义如下：

 

CREATE TABLE [dbo].[News](
    [NewsID] [int] IDENTITY(1,1) NOT NULL PRIMARY KEY,
    [NewsTypeID] [int] NULL,
    [NewsTitle] [nvarchar](50),
    [PeopleID] [int] NULL,
    [NewsContent] [nvarchar](max),
    [NewsHot] [int] NULL,
    [NewsClick] [int] NULL,
    [NewsAddTime] [datetime] NULL,
    [IsCheck] [int] NULL,
    [CheckPeople] [int] NULL,
    [CheckTime] [datetime] NULL) 

现在我们要做的就是取出记录的第10条到第20条：

 

SELECT TOP   10  *  FROM  News   WHERE   NewsID NOT IN   
(SELECT   TOP   10   NewsID     FROM   News ORDER   BY   NewsID   DESC )   
ORDER   BY   NewsID   DESC