普通SP如何处理托管SP抛出的异常

I read that SQL exceptions are treated as normal exceptions in managed SPs; I would like to know how is following scenario handled w.r.t to this.I read that SQL exceptions are treated as norma