SQL Server存储过程错误处理

I have a stored procedure which is runs automatically every morning in SQL Server 2008 R2, part of this stored procedure involves executing other stored procedures. The format can be summarised thus:I have a stored procedure which is runs automat