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
