How to handle exception in stored procedure in sql

Question

Hi frnds Please give the example for exception handling in stored procedure.which I can explain an interview. I went for the interview they asked me this qus I said to them and like try catch ,but they didn't satisfied.please give me example