showplan_all

USE AdventureWorks2012; GO SET SHOWPLAN_ALL ON; GO -- First query. SELECT BusinessEntityID  
FROM HumanResources.Employee WHERE NationalIDNumber = '509647174'; GO -- Second query. 
SELECT BusinessEntityID, EmergencyContactID  FROM HumanResources.Employee 
WHERE EmergencyContactID LIKE '1%'; GO SET SHOWPLAN_ALL OFF; GO      

from:http://msdn.microsoft.com/en-us/library/ms187735.aspx

轉載于:https://www.cnblogs.com/sandy_liao/archive/2012/04/13/2445631.html