How to Pass Where clause dynamically in Microsoft SQL

Content

Hi,

I need to pass where clause conditions value dynamically while running sql statements for Microsoft SQL. Here is my query: 

SELECT *
FROM [ServicePackTest].[dba].[s1_name_and_address] 
WHERE name_and_address_id  =  #id

But this doesn't work. Please advise.