Re: Stored Procedure for Paging

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: SriSamp (ssampath_at_sct.co.in)
Date: 10/13/04

  • Next message: SriSamp: "Re: In what language was SQL Server 2005 (Express) written?" 
    Date: Wed, 13 Oct 2004 14:29:14 +0530

    See if these help:
    http://weblogs.sqlteam.com/jeffs/archive/2004/03/22/1085.aspx
    Check out the database code for the same. 

    -- 
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"Prabhat" <not_a_mail@hotmail.com> wrote in message
news:eMiHc5PsEHA.2800@tk2msftngp13.phx.gbl...
> Hi All,
>
> Can I have a Optimized Stored Procedure which will return the Data in
Page?
>
> I have a Table with around a Bilion or records. The Stored procedure
should
> work like ADO Page technique.
> I have read some pages:
>
http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_2
> 1111881.html
> http://www.4guysfromrolla.com/webtech/062899-1.shtml
> http://www.experts-exchange.com/Databases/Oracle/Q_21116730.html
>
> But I think there will be a optimized way to do Pagin with in Stored
> Procedure. Can any of friend send a sample of that?
>
> I wanted to Display the Data in a GRID (Delphi using ADO). But in Delphi
the
> ADO does not support the PAGE Like in VB - I think.
>
> Thanks
> Prabhat
>
>
  • Next message: SriSamp: "Re: In what language was SQL Server 2005 (Express) written?"

    Relevant Pages

    • Re: Stored Procedure for Paging
      ... The Stored procedure ... > I wanted to Display the Data in a GRID (Delphi using ADO). ...
      (microsoft.public.sqlserver.server)
    • Re: Stored Procedure for Paging
      ... > Can I have a Optimized Stored Procedure which will return the Data in> Page? ... > I wanted to Display the Data in a GRID (Delphi using ADO). ...
      (microsoft.public.sqlserver.server)
    • Re: Stored Procedure for Paging
      ... > Can I have a Optimized Stored Procedure which will return the Data in> Page? ... > I wanted to Display the Data in a GRID (Delphi using ADO). ...
      (microsoft.public.sqlserver.programming)
    • Delphi 2005, ADO, XML
      ... Could someone plz post a working example of retrieving XML data ... Delphi 2005, Microsoft SQL Server 2000. ... I have a stored procedure called myStoredProc which returns ... Comprehensive help on ADO w/ Delphi is almost non-existent! ...
      (borland.public.delphi.database.ado)
    • Stored Procedure for Paging
      ... Can I have a Optimized Stored Procedure which will return the Data in Page? ... I wanted to Display the Data in a GRID (Delphi using ADO). ...
      (microsoft.public.sqlserver.programming)