Sql Server 2005
DECLARE @PageIndex INT;
DECLARE @PageSize INT;
SET @PageSize = 3;
SET @PageIndex = 1;
DECLARE @StartIndex INT;
DECLARE @EndIndex INT;
SET @StartIndex = @PageSize * (@PageIndex-1) +1;
SET @EndIndex = @StartIndex + @PageSize - 1;
WITH ProductEntires AS(
SELECT
ROW_NUMBER() OVER (ORDER BY [UpdateDate] DESC) AS RowIndex,
[ID],
[ProductName],
[ProductDescription],
[ProductImage1],
[ProductTitle1],
[VotedAmount]
FROM
[TblProduct]
)
SELECT *
FROM ProductEntires
WHERE
[RowIndex] BETWEEN @StartIndex AND @EndIndex
Posts
