[MS-SQL] 트랜젝션 / MS-SQL TRANSACTION

 

 

 

ALTER PROCEDURE [dbo].[sp_X_EXAMPLE_TRAN]
	@OUT_RETURN INT OUTPUT   -- 오류 : 0, 성공 :1
AS
BEGIN

SET NOCOUNT ON;

BEGIN TRY
	BEGIN TRAN
	DELETE FROM TBL_TEST 
	SELECT CAST('@ZZZ' AS INT)
	COMMIT TRAN -- 성공!
	SET @OUT_RETURN = 1
END TRY

BEGIN CATCH
	ROLLBACK TRAN -- 실패!
	
	SET @OUT_RETURN = 0
END CATCH

	
	
END