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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Error handling in function

Author  Topic 

anandc
Starting Member

20 Posts

Posted - 2005-09-05 : 04:51:10
Hi, I have one function that returns table type data. I want to do some error handling in the function and in case of any error while execution i want to return the error code to the calling program/SP. How can I do this?
Thanks

- Anand

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-09-05 : 04:55:25
See if these are helpful
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -