Adding rows to a table with identity column page 2
Let's consider a table with a single auto-increment column (SQL Server):
How to insert rows into above table? If you'll try to not specify a value
Surely, we could insert specific value when turning the counter off:
The task we are trying to solve is being worded as: "How to insert namely successive values of a counter into a table?" It turns out that answer is obvious, it lies in Standard syntax:
It is hardly imagined that you'll use DEFAULT VALUES in other situations, as existence of primary key allow you to use that clause only once when inserting default values for all the columns of table. But here we can rerun the above statement as many times as many successive values we need in a table.
But what about other DBMS?