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