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 |
|
keka3309
Starting Member
11 Posts |
 Posted - 2013-04-10 : 09:27:15
|
| Hi ,I got a stored proc in which will i truncate a table load some data in to it. How do i know the procedure executed successfully and what are the best practices for error handling. its simple table with no constraints etc.any help is much appreciated ThanksKeka |
|
|
bandi
Master Smack Fu Yak Hacker
2242 Posts |
Posted - 2013-04-10 : 09:40:54
|
| Use TRY...CATCH mechanism for handling run-time exceptionsRefer this link....http://msdn.microsoft.com/en-us/library/ms175976(v=sql.90).aspx |
 |
|
|
|
|
|
Error Handling in Storedproc in sqlserver 2005