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.
| Author |
Topic |
|
sqlnovice123
Constraint Violating Yak Guru
262 Posts |
 Posted - 2006-02-07 : 12:51:56
|
| HelloI read that the FAST_FORWARD option is a READ ONLY. Isn't the default for a CURSOR READ ONLY? When else do we give the FAST_FORWARD option in a CURSOR declaration.DECLARE MDList CURSOR LOCAL FAST_FORWARDThanks in advance!sqlnovice123 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-07 : 12:58:12
|
| no, updates can be made through cursors. Anyway, you want to completely avoid using cursors though. Use a set based approach, or table vars or even temp tables instead of a cursor. Tell us what you are trying to do and give us some specifics (table ddl, sample data, expected output, etc.) and we can help you use something other than a cursor.-ec |
 |
|
|
|
|
|
Using FAST_FORWARD in a CURSOR