NOT NULL in SQL Server

In a relational database, a null value is used when a column’s value is absent or ambiguous. A null is not a zero value or an empty string. In other words, It is a special marker used in SQL to denote the absence of a data value from the database.

As a value, a restriction, and a filter condition, NULL is utilized. NOT NULL, on the other hand, cannot be used as a value but will be used as a constraint and helps to filter the search results. The examples that will teach you how to utilize NOT NULL are provided below.

NOT NULL as a constraint:
CREATE TABLE tbEmployee (
iEmployeeID INT PRIMARY KEY, 
vcEmployeeName VARCHAR(100) NULL,
dtHireDate DATETIME NOT NULL);

NOT NULL as a filter condition:
SELECT * FROM tblEmployee WHERE vcEmployeeName IS NOT NULL;
SELECT * FROM tblLocation WHERE (longitude IS NOT NULL AND latitude IS NOT NULL);

Hope you find this article helpful.