How we can develop database paging using PLSQL in Sql Server 2005?

Question

Hai, friends anybody explain the different types of BACKUPs available in SQL Server 2005

Answer 1

DECLARE @StartRow INT

DECLARE @EndRow INT

SET @StartRow = 120

SET @EndRow = 140

SELECT Col1, Col2, Col3

FROM

(

SELECT A.Col1, A.Col2, A.Col3,

ROW_NUMBER() OVER(Order BY A.Col1, A.Col2, A.Col3) AS RowNumber

FROM tblTest A

) Test

WHERE RowNumber > @StartRow AND RowNumber < @EndRow

ORDER BY Col1, Col2, Col3