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 |
|
Mahavirjadhav
Starting Member
18 Posts |
 Posted - 2014-08-06 : 05:47:23
|
| Please can any one help me how sql server internally handles errors occurred in stored procedure.Mahavir |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-08-06 : 11:41:08
|
Have you looked up "BEGIN TRY" and BEGIN CATCH" in Books Online?
Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2014-08-12 : 09:08:11
|
| Within the BEGIN TRY .. BEGIn CATCH you can display various information about the error, such as ERROR_NUMBER() , ERROR_SEVERITY()Jack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
|
|
|
How sql server handles exception in SP