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 |
|
gpiva
Starting Member
47 Posts |
 Posted - 2005-08-30 : 00:09:04
|
| Hi Guys I need some advice on a tedius topicI have some sp that incapsulate business logic and transactionsI read on an article that if you dont use error handling in the store procedure you will be never sure that the transsaction was successfull, to make it more clare if I run a sp likesp_submitApplicationbegin transactioninsert into QUAinsert into LABinsert into CABcommit transactionWITHOUT an appropriate @error handling sql server WILL commit in any case my transaction even if 'insert into LAB' didn't do the job due for an error.is this TRUE??Any help will be appreciate.Carlo |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
|
|
|
|
|
error handling
