The syntax of the WHERE clause with the IS NULL clause : IS NULL « Query « SQL Server / T-SQL Tutorial






WHERE expression IS [NOT] NULL

The contents of the NullSample table

SELECT * FROM NullSample








1.8.IS NULL
1.8.1.The syntax of the WHERE clause with the IS NULL clause
1.8.2.A SELECT statement that retrieves rows with null values
1.8.3.IS NULL and = NULL