Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
write a cursor
- Thread starter cazeno
- Start date
nikhilmehrotra
Programmer
Hi,<br><br>what kind of cursor do u want to write.<br><br>the general structure for the cursor is<br><br>CREATE <cursorname> CURSOR FOR<br> <your select query><br><br>OPEN <cursorname><br>FETCH FIRST FROM <cursorname> INTO <field list specefied in the select query><br><br>WHILE @@FETCH_STAUS <> -1 /* For checking that you have not crossed the end of the cursor*/<br>BEGIN<br> /* your processing based on the rows given by the sever*/<br><br> FETCH NEXT FROM <cursorname> INTO <field list specefied in the select query><br>END<br>CLOSE <cursorname><br>DEALLOCATE <cursorname><br><br><br>Hope this helps.<br><br><br>Nikhil<br>(<A HREF="mailto:nikhilmehrotra@mailmetoday.com">nikhilmehrotra@mailmetoday.com</A>)<br>
- Status
Similar threads
- Locked
- Question