views:

81

answers:

4

I have a table created with the following schema:

CREATE TABLE [dbo].[Visualizations]
(
    VisualizationID     int identity (1,1)      NOT NULL
)

Since the table has no settable fields, I'm not sure how to insert a record. I tried:

INSERT INTO [Visualizations];
INSERT INTO [Visualizations] () VALUES ();

Neither work. What is the proper syntax to do this?

Edit: Since a number of people seem confused by my table, it is used purely to represent a parent of a number of sub-tables... each one references this table by FK and each of those FKs are PKs, so that across all of those tables, the IDs are unique.

+11  A: 

See this (example "F. Load data using the DEFAULT VALUES option"):

INSERT INTO [Visualizations] DEFAULT VALUES;
Anton Gogolev
A: 

What you are doing doesn't seem to make too much sense. But, you could try setting IDENTITY_INSERT to OFF and then insert some values. When done, set IDENTITY_INSERT to ON.

Randy Minder
+1  A: 

Trigger the identity insert with null

insert into
            Visualizations
values
           (null);
Sophie88
A: 

Maybe you need to add a dummy column to do this, and just insert NULL into it, the dummy column would allow for NULLs. Although your table structure does not make sense, I would suggest this in order for it to work.

Hope this helps, Best regards, Tom.

tommieb75