Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

like image 960
volume one Avatar asked Sep 17 '14 21:09

volume one


1 Answers

Use the DEFAULT VALUES option:

INSERT INTO IndentitySpecification
DEFAULT VALUES;
like image 71
D Stanley Avatar answered Oct 05 '22 23:10

D Stanley