Looping thro a recordset in SP


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Looping thro a recordset in SP

  1. #1
    Xion Guest

    Looping thro a recordset in SP


    Is it possible to loop thro a recordset when a SELECT statement is executed
    in stored proc.
    Basically something like, when using ADO to exec a SELECT, it is possible
    to go thro the recordset.

    Any help is appreciated.

    Thanks


  2. #2
    Kevin Guest

    Re: Looping thro a recordset in SP


    You would have to use a cursor. I don't know of any other options. Look up
    the 'DECLARE CURSOR' or the 'FETCH' Transact-SQL commands in the SQL books
    online.

    "Xion " <grajput@infoed.org> wrote:
    >
    >Is it possible to loop thro a recordset when a SELECT statement is executed
    >in stored proc.
    >Basically something like, when using ADO to exec a SELECT, it is possible
    >to go thro the recordset.
    >
    >Any help is appreciated.
    >
    >Thanks
    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center