问题描述:联合主键不能粘贴多行!
引用外部数据表Table_test(主键分别为:A,B,C)
SQLServer2008
建表语句:
CREATE TABLE [dbo].[Table_test](
[A] [int] NOT NULL,
[B] [varchar](40) NOT NULL,
[C] [int] NOT NULL,
[D] [varchar](20) NULL,
[E] [varchar](50) NULL,
CONSTRAINT [PK_Table_test] PRIMARY KEY CLUSTERED
(
[A] ASC,
[B] ASC,
[C] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]