开发者

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
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜