有不好的地方 还请大家指教
ALERT PROCEDURE sp_TRANSACTIONTEST
(
@in_TEST int = null
) AS
DECLARE @out_Flag smallint
SET NOCOUNT ON
BEGIN TRANSACTION
UPDATE 表
SET 字段 = 值
IF @@ERROR <> 0
GOTO ERROR
INSERT INTO 表
(字段1
,字段2)
VALUES (
值1
,值2)
IF @@ERROR <> 0
GOTO ERROR
END
SET @out_Flag = 1
COMMIT TRANSACTION
SELECT @out_Flag
RETURN
ERROR:
SET @out_Flag = 0
ROLLBACK TRANSACTION
SELECT @out_Flag
RETURN
(
@in_TEST int = null
) AS
DECLARE @out_Flag smallint
SET NOCOUNT ON
BEGIN TRANSACTION
UPDATE 表
SET 字段 = 值
IF @@ERROR <> 0
GOTO ERROR
INSERT INTO 表
(字段1
,字段2)
VALUES (
值1
,值2)
IF @@ERROR <> 0
GOTO ERROR
END
SET @out_Flag = 1
COMMIT TRANSACTION
SELECT @out_Flag
RETURN
ERROR:
SET @out_Flag = 0
ROLLBACK TRANSACTION
SELECT @out_Flag
RETURN