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/p/2445631.html