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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-01-08 : 08:06:15
|
| Anas writes "While calling a stored procedure without any transaction, if one of the statements fail, what happens to the other statements, will they commit?" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-01-08 : 08:28:59
|
| If there is no transaction, each statement is started in its own transaction. So even if one statement fails, rest of the statement in the batch continues to execute.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
|
|
|
Status of other statement in a stored procedure while one st