创建事务

begin transaction

if(@@error<>0)

       begin

              rollback transaction

              set @result=1

              return

       end

commit transaction

set @result=0

return