Web Listing 1: Queries That Use FORCED Parameterization

DBCC FREEPROCCACHE;
GO
SELECT ProductID, UnitPrice, OrderDate,
   h.ModifiedDate 
FROM Sales.SalesOrderDetail d
	JOIN Sales.SalesOrderHeader h
	  ON d.SalesOrderID = h.SalesOrderID
WHERE d.SalesOrderID = 58755
AND SalesOrderDetailID = 67075;
GO
SELECT ProductID, UnitPrice, OrderDate,
   h.ModifiedDate 
FROM Sales.SalesOrderDetail d
	JOIN Sales.SalesOrderHeader h
	  ON d.SalesOrderID = h.SalesOrderID
WHERE d.SalesOrderID = 51721
AND SalesOrderDetailID = 39797;
GO