SQL Inserting rows with NULL fields


Example

For example inserting an employee with no phone number and no manager into the Employees example table:

INSERT INTO Employees
    (Id, FName, LName, PhoneNumber, ManagerId, DepartmentId, Salary, HireDate)
VALUES
    (5, 'Jane', 'Doe', NULL, NULL, 2, 800, '2016-07-22') ;