| Subject | Advantages of using CURSOR |
|---|---|
| Author | W O |
| Post date | 2013-12-15T19:25:39Z |
Hello everybody
If in a stored procedure I need to extract data from a table I can use a FOR SELECT or a DECLARE VARIABLE MyVar CURSOR FOR ( .... ) statement.
Which would be the advantage of using CURSOR FOR?
In which cases it is better than a FOR SELECT?
Greetings.
Walter.