sql 存储过程中的事务

ALTER PROCEDURE update_applicationDesigntable_applicationTable
@NewapprovePersons nvarchar(50),--新审批人
@NewApproveMen nvarchar(50),--//新审批人组
@applicationType int,
@OldApproveMen nvarchar(50),--//原审批人
@OldapprovePersons nvarchar(50)--//原审批人组

AS

begin tran
declare @strLenth int

update ApplicationDesignTable set ApprovePersons=@NewapprovePersons where applicationType=@applicationType and ApprovePersons=@OldapprovePersons

if(@@error<>0)goto errhandle 

begin

update Application_table set ApproveMen= left(ApproveMen,len(ApproveMen)-len(@OldApproveMen))+@NewApproveMen where patindex('%'+@OldApproveMen,ApproveMen)<>0
commit tran
end
if(@@error<>0)goto errhandle 

errhandle:
begin
  if (@@error<>0)
   rollback tran
end