If I have a table with only an auto-increment column, how do I insert into it?
auto-increment, insert, sql-server
Solution
insert into mytable default values
Problem
A colleague asked me, if you have a table in SQL Server with only an auto-increment column, how do you insert a new row into that table? ``` INSERT INTO MyTable() VALUES() ``` ...doesn't work. As for why... I'm not really sure. But I found the question kind of compelling.