PROC怎么遇到错误全局rollback---SQLServer 异常的处理

ALTER PROCEDURE [dbo].[PROC_SMSACTIVE_UPDATE]
AS
BEGIN
SET XACT_ABORT ON