How do you pass parameters to stored procedures? Stored procedures allow you to pass parameters to them, either input or output parameters. ● Input Parameters: These allow you to send data to the procedure. ● Output Parameters: These allow the procedure to send data back to the caller. Example: SQL Server: CREATE PROCEDURE GetEmployeeSalary (@emp_id INT)
BEGIN
SELECT salary FROM employees WHERE id = @emp_id;END;
- Calling the procedure:
EXEC GetEmployeeSalary @emp_id = 101;- MySQL:
DELIMITER //
CREATE PROCEDURE GetEmployeeSalary(IN emp_id INT)
BEGIN
SELECT salary FROM employees WHERE id = emp_id;END //
DELIMITER ;
- Calling the procedure:
CALL GetEmployeeSalary(101);