Try & Catch In Stored Procedure

Dec 11 2011 6:40 AM

Hi Friends..

I want to know, How to use of try & Catch block in stored procedure ?
Please explain with example ?

Thanks...