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 |
|
|
|
|
|