stored procedure in sql with parameters code example

Example: create select stored procedure in sql server

CREATE PROCEDURE sp_getRaces
AS
BEGIN 
SELECT * FROM dbo.Races
END ;