How to insert row a in one column (PK) table?
I have a table with one and only one column, which is an identity column (PK) of this table. How to insert row in this table?
INSERT INTO table_name
doesn't work, neither does:
INSERT INTO table_name() VALUES()
VALID SOLUTION FROM THE ANSWER:
开发者_高级运维INSERT INTO table_name DEFAULT VALUES
DECLARE @TABLE TABLE
(
ID INT IDENTITY(1,1) PRIMARY KEY
)
INSERT INTO @TABLE DEFAULT VALUES
SELECT * FROM @TABLE
You should enable identity insert on the table, so that you can insert values into the column.
SET IDENTITY_INSERT table_name ON
精彩评论