MSSQL 프로시저 Try Catch 트랜잭션

BEGIN TRY
	SET XACT_ABORT ON;
	BEGIN TRANSACTION
	-- logic processing
	-- optional : other procedure call
	COMMIT TRANSACTION
END TRY
BEGIN CATCH
	ROLLBACK TRANSACTION
END CATCH

이런식으로 작성 하자~