Database

DECLARE @page_num int<br />
DECLARE @rows_in_page int<br />
DECLARE @temp1 TABLE ( aaa nVarchar(100), bbb nVarchar(200), ccc float, ddd int)<br />
DECLARE @SQL nvarchar(4000)<br />
<br />
SET @page_num = 3<br />
SET @rows_in_page = 15<br />
INSERT INTO Temp1 = SELECT * FROM myTable<br />
[[[ now @temp has all records ]]]<br />
<br />
[--> some code to delete the first 30 records ((page_num-1)*rows_in_page) <--]<br />
[[[ now @temp1 has pages 3,4,5,6,.... ]]]<br />
<br />
SET @SQL = 'SELECT TOP ' + @rows_in_page + ' * from @temp1'<br />
[[[ now the variable @SQL = "SELECT TOP 15 * from @temp1" ]]]<br />
<br />
<br />
EXECUTE (@SQL)<br />
[[[ the EXECUTE will give me the first 15. That means only page 3 ]]]

<br />
<br />
use northwind<br />
go<br />
<br />
--create temporary table to store all rows with identity column or serial number for page filter <br />
CREATE TABLE #OrdersPage ([Iden] [int] IDENTITY(1,1) NOT NULL, OrderId int,CustomerID nchar(10))<br />
<br />
declare @startpage int<br />
declare @endpage int<br />
declare @rows int<br />
declare @currentpage int<br />
<br />
set @rows = 10 -- number of rows per page from the front end<br />
set @currentpage = 1  -- pass current page from the front end<br />
<br />
set @endpage = (@rows * @currentpage) + 1<br />
set @startpage = @endpage - @rows<br />
<br />
print @startpage <br />
print @endpage <br />
<br />
insert into #OrdersPage <br />
select top 50 OrderID, CustomerID from Orders<br />
<br />
select * from #OrdersPage where Iden >= @startpage and Iden < @endpage <br />
-- set paging condition here using the column 'Iden' from the temporary table<br />
<br />
drop table #OrdersPage<br />
<br />

DECLARE @QAZ AS DATETIME<br />
SET DATEFORMAT dmy;SET @QAZ = '14-02-2007'<br />
print @QAZ