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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Cursor Variables

Status
Not open for further replies.
tondarb

tondarb

Programmer
Oct 8, 2003
37
US
Hi
Is there any way where we can Refer the Columns in a Cursor Variable Without Defining Separate Variables For Fetching The Values in the Cursor

Regards
 
Sort by date Sort by votes
No as far as I now you must fetch the field from the Cursor into a variable.
 
Upvote 0 Downvote
But it is a bad practice to use cursors as they are extremely inefficient. Are you sure you can't do the same thing with a set-based statement?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SaltyTheFrog
  • Locked
  • Question
Rework process not to use cursor 2
Replies
3
Views
70
gbaughma
gbaughma
wbodger
  • Locked
  • Question
Using OUTPUTand Table variables
Replies
3
Views
125
Olaf Doschke
Olaf Doschke
Sahubba
  • Locked
  • Question
Updating Variables 2
Replies
6
Views
84
gmmastros
gmmastros
Skittle
  • Locked
  • Question
SQL Term 'Cursor'
Replies
2
Views
62
johnherman
johnherman
DougP
  • Locked
  • Question
HELP!! somehow I lost all of the variables when I run DEBUG in SSMS
Replies
1
Views
39
DougP
DougP

Part and Inventory Search

Sponsor

Back
Top