How to write a parametrized query in management studio?

Question

From a client application I tyipically do:

select * from table where Name = :Parameter 

and then before executing the query I do

:Parameter = 'John' 

These parameters are not a Search&Replace but real parameters passed to the server. Since I need to test some of those queries in detail, how can I write the query in management studio?

I want to write the query with parameters and give a value to the parameter. How can this be done?

Update:

To remove confusion here I add info to better express myseld.

when I execute a normal query I see in sql server profiler

select * from table where Name = 'John' 

while when I execute a parametrized query I see this:

exec sp_executesql N'select * from table  where Name = @P1',N'@P1 varchar(8000)','John' 

This is why I say it is not a search and replace.

Answer 1

How about something like

DECLARE @Parameter VARCHAR(20) SET @Parameter = 'John'  SELECT * FROM Table WHERE Name = @Parameter