execute stored procedure with select statement as input parameters code example

Example: sql server execute stored procedure with parameters

CREATE PROCEDURE dbo.uspGetAddress @City nvarchar(30) AS
SELECT * FROM Person.Address WHERE City = @City

EXEC dbo.spGetAddress @City = 'Bordeaux'