Listing 2: Recreating the Stored Procedure WITH RECOMPILE
ALTER PROC getorders
(@custID nchar(5) )
WITH RECOMPILE
AS
SELECT * FROM orders
WHERE CustomerID = @custID