The insertion of values into some (but not all) of a table's columns usually requires the explicit specification of the corresponding columns. : Insert « Insert Delete Update « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Insert Delete Update
3. Insert

The omitted columns must be either nullable or have a DEFAULT value.

6> CREATE TABLE employee(
7>    id          INTEGER NOT NULL PRIMARY KEY,
8>    first_name  VARCHAR(10),
9>    last_name   VARCHAR(10),
10>    salary      DECIMAL(10,2),
11>    start_Date  DATETIME,
12>    region      VARCHAR(10),
13>    city        VARCHAR(20),
14>    managerid   INTEGER
15> );
16> GO
1> INSERT INTO employee (id) VALUES (3);
2> GO

(1 rows affected)
1>
2> select * from employee;
3> GO
id          first_name last_name  salary       start_Date              region     city                 managerid
----------- ---------- ---------- ------------ ----------------------- ---------- -------------------- -----------
          3 NULL       NULL               NULL                    NULL NULL       NULL                        NULL

(1 rows affected)
1>
2>
3>
4>
5> drop table employee;
6> GO
1>