How do you create a stored procedure in SQL Server, PostgreSQL, or MySQL?

SQL Server:

CREATE PROCEDURE GetEmployeeDetails (@emp_id INT)

BEGIN

SELECT * FROM employees WHERE id = @emp_id;

END;

PostgreSQL:

CREATE OR REPLACE FUNCTION GetEmployeeDetails(emp_id INT)

RETURNS TABLE(id INT, name VARCHAR) AS $$

BEGIN

RETURN QUERY SELECT id, name FROM employees WHERE id = emp_id;

END;

$$ LANGUAGE plpgsql;

MySQL:

DELIMITER //

CREATE PROCEDURE GetEmployeeDetails(IN emp_id INT)

BEGIN

SELECT * FROM employees WHERE id = emp_id;

END //

DELIMITER ;

The syntax varies slightly between the databases, but the core idea remains the same.