begin try begintransaction BEGIN insert语句 insert 语句 update语句 select语句 committransaction END TRY begin catch set@msg='失败说明'+char(13)+'行号:'+cast(ERROR_LINE() asvarchar)+char(13)+'错误信息:'+ ERROR_MESSAGE() ROLLBACKTRANSACTION raiserror99999@msg return (-1) end catch return0