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 |
|
CrazyT
Yak Posting Veteran
73 Posts |
 Posted - 2010-04-29 : 14:35:01
|
| I have a query that pulls 25k reocrds into a temp tablei begin transit then updates one table, inserts into another, and then updates a 3rd.end trans and commitsdo i need to surround each one with a begin end if i want to wait for the first to finish, then the second, etc |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-30 : 01:48:24
|
| if you want to capture errors in b/w wrap all of them inside TRY block as Tara suggests. Errors will be captured by TRY block and you can do apropriate actions inside CATCH block. For version before 2005 use IF @@ERROR > 0 check and do rollback and raise error messages.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
begin end in stored procedure