使用IDENTITY列将INSERT记录记录到SQL表

CREATE TABLE Notes(
    NoteID [int] IDENTITY(1,1) NOT NULL,NoteTitle [nvarchar](255) NULL,NoteDescription [nvarchar](4000) NULL
) CONSTRAINT [PK_Notes] PRIMARY KEY CLUSTERED 
(
    NoteID ASC
)WITH (PAD_INDEX  = OFF,STATISTICS_NORECOMPUTE  = OFF,IGNORE_DUP_KEY = OFF,ALLOW_ROW_LOCKS  = ON,ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

而且我想从临时表中复制记录,包括使用sql查询的NoteID ..

这是我的脚本：

SET IDENTITY_INSERT Notes OFF

INSERT INTO Notes (NoteID,NoteTitle,NoteDescription)
SELECT NoteID,NoteDescription from Notes_Temp

SET IDENTITY_INSERT Notes ON

用这个脚本,我收到一个错误：

Cannot insert explicit value for identity column in table 'Notes' when IDENTITY_INSERT is set to OFF.

有没有其他方法可以使用sql查询将标识列插入到表中？

解决方法

SET IDENTITY_INSERT Notes ON

INSERT INTO Notes (NoteID,NoteDescription from Notes_Temp

SET IDENTITY_INSERT Notes OFF

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!