[MSSQL] 예외처리 기법 (MSSQL, MYSQL)

SQL Server code: 

CREATE PROCEDURE dbo.spGetProdNum 
@Id int 
AS 
IF @id = 0 
GOTO ERR_TRAN 
INSERT INTO mess_log VALUES ('Ok') 
ERR_TRAN: 
INSERT INTO err_log VALUES ('Error') 

MySQL code: 

CREATE PROCEDURE spGetProdNum(v_Id INT) 
BEGIN 
ERR_TRAN: 
BEGIN 
IF v_Id = 0 then 
LEAVE ERR_TRAN; 
END IF; 
INSERT INTO mess_log VALUES('Ok'); 
END; -- the end of ERR_TRAN block 
INSERT INTO err_log VALUES('Error'); 
END;