Inserting rows with NULL fields

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') ;

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents