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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Handling cursors and fetch commands

Status
Not open for further replies.

programmher

Programmer
May 25, 2000
235
US
Does anyone know of an example I can follow that shows me how to handle fetch commands and cursors?

The existing stored proc is as follows:

OPEN MyFirstCursor

FETCH From MyFirstCursor INTO MyTabe
@var1,
@var2,
@var3

WHILE @@FETCH_STATUS <> -1
Begin next step


This is my first time encountering such an animal. Can anyone offer assistance?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top