Shulou(Shulou.com)06/01 Report--

Process one:

Select top N entry record * from article table where id not in (select top M entry record id from article table order by id desc) order by id desc

Process two:

Select top N entry record * from article table where id 0

BEGIN

Set nocount on

DECLARE @ PageLowerBound int

DECLARE @ StartID int

DECLARE @ sql varchar

SET @ PageLowerBound = @ PageSize * (@ PageIndex-1)

IF @ PageLowerBound 0

BEGIN

Set nocount on

DECLARE @ PageLowerBound int

DECLARE @ StartID int

DECLARE @ sql varchar

SET @ BeginIndex = @ PageSize * (@ PageIndex-1)

IF @ BeginIndex 0

BEGIN

Set nocount on

DECLARE @ PageLowerBound int,@StartID int,@sql nvarchar

SET @ PageLowerBound = @ PageSize * (@ PageIndex-1)

IF @ PageLowerBound

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.