How to count NULL values in all column in Table?

To solve this problem first create sample table


CREATE TABLE Employee
(
EmployeeId INT,
EmployeeName VARCHAR(50),
Contact INT
)
 
INSERT INTO Employee
VALUES(101,'Rishi Sanuj',NULL),(102,NULL,NULL), (103,NULL, 123456)

SELECT *FROM Employee

SELECT EmployeeId,
SUM(CASE WHEN EmployeeName IS NULL THEN 1 ELSE 0 END)
+ SUM (CASE WHEN Contact IS NULL THEN 1 ELSE 0 END) AS NumberOfNull

FROM Employee

GROUP BY EmployeeId