I usually use following way to write my stored procedure:

```
ALTER PROCEDURE MasterInsertUpdateDelete  
    (@id INTEGER,  
     @first_name VARCHAR(10),  
     @last_name VARCHAR(10),  
     @salary DECIMAL(10,2),  
     @city VARCHAR(20),  
     @StatementType NVARCHAR(20) = '')  
AS  
BEGIN  
    IF @StatementType = 'Insert'  
    BEGIN  
        INSERT INTO employee (id, first_name, last_name, salary, city) 
        VALUES (@id, @first_name, @last_name, @salary, @city)  
    END  

    IF @StatementType = 'Select'  
    BEGIN  
        SELECT * FROM employee  
    END  

    IF @StatementType = 'Update'  
    BEGIN  
        UPDATE employee 
        SET First_name = @first_name, 
            Last_name = @last_name, 
            salary = @salary,  
            city = @city  
        WHERE id = @id  
    END  
    ELSE IF @StatementType = 'Delete'  
    BEGIN  
        DELETE FROM employee 
        WHERE id = @id  
    END  
END

```

The second way is to split the one stored procedure into 4 separate stored procedures for insert, delete, select and update the table.

Which one is recommended with respect to performance ?