Home > IT Answers > Database > While loop Vs Cursor
Just dream
5 pts.
 While loop Vs Cursor
Database, Development, WHILE Loop
What is difference between navigating records in while loop and cursor ?

Software/Hardware used:
ASKED: May 7, 2008  4:16 AM
UPDATED: May 7, 2008  6:47 PM
RELATED QUESTIONS
Answer Wiki:
In a cursor you load all the records into memory and run through the records running a command for each one. In a while loop you run the same command over and over until a condition it met which then terminates the loop.
Last Wiki Answer Submitted:  May 7, 2008  6:46 pm  by  Denny Cherry   64,550 pts.
All Answer Wiki Contributors:  Denny Cherry   64,550 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.

Denny Cherry
 64,550 pts.