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 |
|
desikankannan
Posting Yak Master
152 Posts |
 Posted - 2010-11-17 : 10:08:05
|
| Hi,can u explain the secanrio where i can use cursorin stored procedureDesikankannan |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2010-11-17 : 10:21:29
|
| It's very rare that you would do this for performance reasons. See Bill's artiole here http://www.sqlteam.com/article/cursor-performance-----------I used to think I wasn't a morning person but it never got better in the afternoon |
 |
|
|
desikankannan
Posting Yak Master
152 Posts |
Posted - 2010-11-17 : 23:12:20
|
quote:
Originally posted by elwoos
It's very rare that you would do this for performance reasons. See Bill's artiole here http://www.sqlteam.com/article/cursor-performance-----------I used to think I wasn't a morning person but it never got better in the afternoon
hi,i have one lakh records, i want to process that record inside thestrored procedure,which is the best way to check the record quicklylooking forward the replyDesikankannan |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-11-18 : 05:39:30
|
quote:
Originally posted by desikankannan
quote:
Originally posted by elwoos
It's very rare that you would do this for performance reasons. See Bill's artiole here http://www.sqlteam.com/article/cursor-performance-----------I used to think I wasn't a morning person but it never got better in the afternoon
hi,i have one lakh records, i want to process that record inside thestrored procedure,which is the best way to check the record quicklylooking forward the replyDesikankannan
What did you mean by process? What do you want to do with each row?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
how to use cursor stored procedure