存储过程事务

CREATE PROCEDURE p_PurOrderAduit
(
   @ID INT,
   @result INT OUTPUT
)
AS
BEGIN

DECLARE 参数...
 BEGIN TRY
    BEGIN TRANSACTION
     insert into ...
    COMMIT TRANSACTION
 END TRY
 BEGIN CATCH
    ROLLBACK TRANSACTION
 END CATCH
END