我有一个表。仅一个自增长字段
CREATE TABLE [ChangeObjectInterface] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
CONSTRAINT [PK_ChangeObjectInterface] PRIMARY KEY CLUSTERED
(
[id]
) ON [PRIMARY]
) ON [PRIMARY]
GO
请问如何向他进行插入
------解决方案--------------------
set identity_insert ChangeObjectInterface on
INSERT INTO [ChangeObjectInterface]([id])
VALUES(1)
set identity_insert ChangeObjectInterface off
/*
(所影响的行数为 1 行)
*/
------解决方案--------------------
关注
------解决方案--------------------
--允许将显式值插入表的标识列中。
set identity_insert changeobjectinterface on
insert into [changeobjectinterface]([id]) values(1)
set identity_insert changeobjectinterface off