How to write T-SQL query with parameters

By    

Write T-SQL query with parameters

Example for using parameter in a query

DECLARE @CityParameter  varchar(50)
SET @CityParameter = 'Paris'
SELECT * FROM Person.Address
WHERE City = @CityParameter
testing query output