LISTING 5: Generic Query on the Customers Table

DECLARE @country char(25)
SET @country  = 'Germany'
SELECT customerid FROM customers
   WHERE gender = 'M' and country = @country