Listing 2: Prepared Query Using a Restrictive Value

DBCC FREEPROCCACHE
GO
EXEC sp_executesql
   N'SELECT * FROM Sales WHERE ContactID < @ID',
   N'@ID int',
   @ID = 3
GO