SQL server Cursor View previous topic :: View next topic  


NFOHump.com Forum Index - Programmers Corner
Page 1 of 1
madmax17




Posts: 17725
Location: Croatia
PostPosted: Wed, 27th Apr 2011 16:53    Post subject: SQL server Cursor
Can anyone explain what it is and does so I can understand it? Why can't you use a procedure instead of it?

I get the triggers and procedures but I don't understand cursors, why do you need to allocate and deallocate them and why is there a while(@@fetch=0) everytime.
Back to top
Ragedoctor




Posts: 2184
Location: (dot)NL
PostPosted: Wed, 27th Apr 2011 17:15    Post subject:
http://en.wikipedia.org/wiki/Cursor_%28databases%29

I can tell you a bit about them but I think you'd be better off asking one of the other guys here on the forums, they seem way more qualified.
Back to top
NFOAC




Posts: 6015
Location: India
PostPosted: Sun, 7th Aug 2011 18:52    Post subject:
SQL works on set based programming , cursors allows row by row processing
Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Programmers Corner
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group