• This also count every row

    SELECT COUNT(coalesce([Name],'')) AS [COUNT(*) This is 8 too] FROM [CountTest];