... until the collector arrives ...

This "blog" is really just a scratchpad of mine. There is not much of general interest here. Most of the content is scribbled down "live" as I discover things I want to remember. I rarely go back to correct mistakes in older entries. You have been warned :)

2009-11-03

SQL Server vs. Identity-only Tables

Using SQL Server, if you want to insert a row into a table that contains only an identity column, you can do it like this:

INSERT INTO mytable DEFAULT VALUES

This circumstance is very unusual, but I have run into it twice... and I forgot how I solved it the first time.

Blog Archive