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 |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2006-10-04 : 06:41:13
|
| GurusCan you please tell me the syntax how we will use this "Fast_forward" hint with the cursor?RegardsNitin |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-04 : 06:53:36
|
| From BoL:DECLARE cursor_name CURSOR [ LOCAL | GLOBAL ] [ FORWARD_ONLY | SCROLL ] [ STATIC | KEYSET | DYNAMIC | FAST_FORWARD ] [ READ_ONLY | SCROLL_LOCKS | OPTIMISTIC ] [ TYPE_WARNING ] FOR select_statement [ FOR UPDATE [ OF column_name [ ,...n ] ] ] Kristen |
 |
|
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
Posted - 2006-10-04 : 07:13:17
|
| Thanks KirstenRegardsNitin |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-10-04 : 12:01:36
|
| Can you tell us why you need cursor? Probably it can be done without that alsoMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Fast_forward