SQL Server insert empty instance

Question

SQL Server 2014

Given a table 'test' with the following fields:

id: int. Primary key. Autoincrement by 1.
creation_date: datetime. GETDATE() by default value.

My intention is to insert an empty statement, just to register the event of the insertion. I thought that as the id is an autoincrement and the creation_date has a value by default, a record could be inserted without specifying any value. I know that this can be done by adding a third field and specifying the value in the insertion, but my question is:

Can something like a plain INSERT INTO test be done?

Thanks

or [How to insert default values in SQL table?](https://stackoverflow.com/questions/8777362/how-to-insert-default-values-in-sql-table) — underscore_d, Oct 23 '17 at 13:07

score 4 · Accepted Answer · answered Oct 23 '17 at 13:03

4

INSERT INTO test DEFAULT VALUES

answered Oct 23 '17 at 13:03

Stanislav Kundii

2,874
1
11
17

thank you for the fast reply – Dacklf Oct 23 '17 at 13:18

SQL Server insert empty instance

1 Answers1