Viewing: riptutorial.com

[ Web Proxy ]

Viewing: https://riptutorial.com/sql/example/11808/inserting-rows-with-null-fields

[Back] [Original]

SQL Tutorial => Inserting rows with NULL fields

[logo rip]

RIP Tutorial

Download SQL (PDF)

Fastest Entity Framework Extensions

Bulk Insert

Bulk Delete

Bulk Update

Bulk Merge

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

[pdf] PDF - Download SQL for free

Previous Next

[logo rip]

Get monthly updates about new articles, cheatsheets, and tricks.

Web Proxy Viewer | New URL | Original Page

SQL

SQL

SQL NULL Inserting rows with NULL fields

Fastest Entity Framework Extensions

Example