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 |
|
gamaz2
Starting Member
31 Posts |
 Posted - 2008-07-09 : 17:50:35
|
| Hi,I was wondering if in sql server there is any way to stop execution of code after processing a row in a cursor and begin processing another row with the click of a button on keyboard. Thanks. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 22:14:23
|
| You have to write frontend app for that since t-sql is not for interactive process. |
 |
|
|
cornall
Posting Yak Master
148 Posts |
Posted - 2008-07-10 : 04:07:22
|
| Can I ask why you want to do this? |
|
|
|
cornall
Posting Yak Master
148 Posts |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2008-07-10 : 08:48:45
|
| The ultimate way to have poor performance....."....in a cursor"And what you are proposing has the potential to cause you nightmares with recordlocking...when users go to lunch and forget to finish their work. |
|
|
|
|
|
|
Stop execution of code after processing one row