sql - How to insert into a table that specifies a DEFAULT value for every column?

Question

I have a table where all columns are auto-populated whenever an insertion happens:

CREATE TABLE …
(
    ItemID      INT       NOT NULL IDENTITY(…),
    DateCreated DATETIME2 NOT NULL DEFAULT GETDATE()
);

How do I write a SQL statement that inserts a new row into this table without having to manually provide any concrete values to insert?

(There is already a similar question, but it differs in that it's about a table with some non-DEFAULT columns for which a value must be manually provided.)

Answer 1

Use the DEFAULT VALUES option:

INSERT INTO IndentitySpecification
DEFAULT VALUES;