Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 use of cursor

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-05-05 : 09:03:07
dipak writes "Dear sir,
plz. help me.wht is the use of cursor in stored procedure when we call from vb6.send me one example plz."

robvolk
Most Valuable Yak

15732 Posts

Posted - 2006-05-05 : 09:04:48
Can anyone enlighten me on the recent obsession with cursor usage? I know school terms are ending, but there seem to be ENTIRE universities devoted to cursor crap.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-05-05 : 09:22:32
Some sql programmers want to use Cursor to simulate front end's while or for loop in sql. Because they are new to sql queries they think of row by row than set based approach. Also most of the interview questions to the newbies are based on Triggers and cursors

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

druer
Constraint Violating Yak Guru

314 Posts

Posted - 2006-05-05 : 13:34:23
Dipak ... look up DECLARE CURSOR in books on line, or on google and you will get all of the information that you are looking for.

Hope it helps,
Dalton

Blessings aren't so much a matter of "if they come" but "are you noticing them."
Go to Top of Page
   

- Advertisement -