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
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