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 |
|
sparrow37
Posting Yak Master
148 Posts |
 Posted - 2010-04-01 : 04:03:32
|
| Hi all,I have a stored procedure which has 5 if statements. In each if statement there are two or three delete statements. I want to apply trasactions and try catch blocks to these if else statements so that all of the delete statements run or none of them run. Also, at one time only one if statement will run. I want to get total number of rows deleted by both/three delete statements in each if condition. How can i do this?Regards,Asif Hameed |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-01 : 05:15:36
|
You can give us example code and then we can provide a solution for this example code.That is much easier for us.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
|
|
|
trasactions/total rows affected.