UsoISNULL.sql

SET SHOWPLAN_TEXT ON;
GO

SELECT JobCandidateID AS 'ID Candidato', BusinessEntityID AS 'ID Entidad'
    FROM HumanResources.JobCandidate
    WHERE ISNULL(BusinessEntityID, 1) <> 1;
GO
SET SHOWPLAN_TEXT OFF;