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

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.)



Solution 1:[1]

Use the DEFAULT VALUES option:

INSERT INTO IdentitySpecification
DEFAULT VALUES;

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1