I am designing a temporal database.
For whatever odd reason, I need each object to have a table with only one column.
Honest to god, this is all I need. If you're curious, my other columns are implimented as separate tables.
Now how do I insert into this table? he SQL syntax I am used to, requires that I have at least one column explicitly set. Normally inserting into a table with an IDENTITY column, you don't explicitly put any value into that column as it should be auto-incrementing. I do not want to use a work-around by putting a dummy column in my table. I hate hacks, work-arounds and unnecissary data.
For whatever odd reason, I need each object to have a table with only one column.
Code:
CREATE TABLE Users
(
id int NOT NULL IDENTITY PRIMARY KEY
)
Honest to god, this is all I need. If you're curious, my other columns are implimented as separate tables.
Now how do I insert into this table? he SQL syntax I am used to, requires that I have at least one column explicitly set. Normally inserting into a table with an IDENTITY column, you don't explicitly put any value into that column as it should be auto-incrementing. I do not want to use a work-around by putting a dummy column in my table. I hate hacks, work-arounds and unnecissary data.