execute flag in sql

Question

CREATE PROCEDURE spTest
@flag INT
AS
BEGIN
IF @flag = 1
-- Insert
IF @flag = 2
-- Update
IF @flag = 3
-- Delete
END

execute pro_name then??

 

help me