IF @@ERROR <> 0 BEGIN SET @errorFlag = 1; ROLLBACK TRAN; END; ELSE BEGIN COMMIT TRAN; END;
formats like this:
IF @@ERROR <> 0 BEGIN SET @errorFlag = 1; ROLLBACK TRAN; END; ELSE BEGINCOMMIT TRAN; END;
Please sign in to leave a comment.
IF @@ERROR <> 0
BEGIN
SET @errorFlag = 1;
ROLLBACK TRAN;
END;
ELSE
BEGIN
COMMIT TRAN;
END;
formats like this:
IF @@ERROR <> 0
BEGIN
SET @errorFlag = 1;
ROLLBACK TRAN;
END;
ELSE BEGIN
COMMIT TRAN;
END;