Skipping procedure

you meant to say, if any exception happens also your SP should run successfully.

---

TRY BELOW CODE:

CREATE PROC SP_1
AS
BEGIN
  SELECT 1/0 AS VAL
END
-----------------
EXEC SP_1
-----------------
CREATE PROC SP_2
AS
BEGIN
 SELECT 1 AS NUM
END
-------------------
EXEC SP_2
-------------------

-- MAIN PROCEDURE
CREATE PROC MAIN1
AS
BEGIN
BEGIN TRY 
  EXEC SP_1
  END TRY
 BEGIN CATCH
  GOTO SECOND_SP
 END CATCH
  SECOND_SP:
    EXEC SP_2
END


--TEST IT
EXEC MAIN1

Thanks.

---

bala krishna