How do you insert into a table comprised entirely from auto-generated values?

Question

Suppose you have a table in SQL Server declared in the following manner:

CREATE TABLE my_table 
(
    id INT IDENTITY(1,1) PRIMARY KEY
);

How do you INSERT into this table? I have tried the following, all to no avail:

INSERT INTO my_table;
INSERT INTO my_table () VALUES ();
INSERT INTO my_table SELECT NULL;

This is alternative: https://stackoverflow.com/questions/1049625/sql-how-to-insert-row-without-auto-incrementing-a-id-column — Michał Turczyn, Feb 11 '18 at 22:06
An initially anaemic relation (read: collation point) for a second bridging table. Eventually the table may have other fields, but not at the outset. — e_i_pi, Feb 11 '18 at 22:41
@MartinSmith could you link to the duplicate? I couldn't find one when searching initially. — e_i_pi, Feb 11 '18 at 22:48
https://stackoverflow.com/questions/25900996/how-to-insert-into-a-table-that-specifies-a-default-value-for-every-column — Martin Smith, Feb 11 '18 at 22:51
Ta, right you are. I wasn't specifying the term "default" when searching (I used auto-generated), I imagine that had an impact. — e_i_pi, Feb 11 '18 at 22:57

Dan Guzman · Accepted Answer · 2018-02-11T22:45:03.853

5

You can specify DEFAULT VALUES as long as all columns are auto-generated, allow null, or have default constraints:

INSERT INTO dbo.my_table DEFAULT VALUES;

edited Feb 11 '18 at 22:45

answered Feb 11 '18 at 22:04

Dan Guzman

1

@JohnCappelletti, thanks for mentioning that. I improved my answer. – Dan Guzman Feb 11 '18 at 22:45

1 Answers1