Listing 4: Examining the Plan Cache to Observe Parameterized Queries

SELECT usecounts, sql
   FROM master..syscacheobjects
WHERE cacheobjtype= 'Compiled Plan'
AND objtype = 'Prepared'
AND dbid = db_id('AdventureWorks');