當 IDENTITY_INSERT 設為 OFF 時,無法將外顯值插入資料表 'in_Consult_M' 的識別資料行中。
请问这是什么原因,我有二个数据库,一个可以插入数据,而另外一个说不能插入数据,现在郁闷呀?请高手帮忙?第二个插入时,报上面的错误.....
请问这是什么原因,我有二个数据库,一个可以插入数据,而另外一个说不能插入数据,现在郁闷呀?请高手帮忙?第二个插入时,报上面的错误.....
调试欢乐多
GO
/****** 对象: Table [dbo].[in_Consult_M] 脚本日期: 12/20/2006 14:27:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[in_Consult_M](
[MasterKey] [int] IDENTITY(1,1) NOT NULL,
[ConsultNo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ConsultName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ConsultNote] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[ConsultCaption] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_in_Consult_M] PRIMARY KEY CLUSTERED
(
[MasterKey] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
USE [Aplus]
GO
/****** 对象: Table [dbo].[in_Consult_M] 脚本日期: 12/20/2006 14:26:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[in_Consult_M](
[MasterKey] [int] IDENTITY(1,1) NOT NULL,
[ConsultNo] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ConsultName] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
[ConsultNote] [ntext] COLLATE Chinese_PRC_CI_AS NULL,
[ConsultCaption] [nvarchar](50) COLLATE Chinese_PRC_CI_AS NULL,
CONSTRAINT [PK_in_Consult_M] PRIMARY KEY CLUSTERED
(
[MasterKey] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]都是一样的
insert into in_Consult_M(col1,col2……)--这里要列出全部列的列名
select col1,col2…… from table--这里也是
set IDENTITY_INSERT in_Consult_M OFF