测试 top (@num) 是否能重用执行计划

参考：

sys.syscacheobjects (Transact-SQL)

点击打开链接

USE [AdventureWorks2014]GODBCC FREESYSTEMCACHE('ALL')GODECLARE @top INTSET @top=3EXEC sp_executesql N'SELECT TOP (@top) * FROM Person.Person AS p',N'@top int',@topSET @top=5EXEC sp_executesql N'SELECT TOP (@top) * FROM Person.Person AS p',N'@top int',@topSELECT cacheobjtype,objtype,[sql] FROM sys.syscacheobjects AS s WHERE s.sql LIKE '%top%' AND s.sql LIKE '%Person%'