CREATE TABLE [dbo].[ta] ( [a] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [b] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [c] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GOALTER TABLE [dbo].[ta] WITH NOCHECK ADD CONSTRAINT [PK_ta] PRIMARY KEY CLUSTERED ( [a], [b] ) ON [PRIMARY] GO insert ta select '001','AB01','sewerw' union select '001','AB02','FWREEW' union select '002','AB03','FWEWRWE' union select '002','AB04','FFWERWE' select * from ta insert ta select '002','AB01','rwerew' select * from ta drop table ta
然后在表设计里面选择A,按住ctrl键,选择B,然后设置主键.
[a] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[b] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[c] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GOALTER TABLE [dbo].[ta] WITH NOCHECK ADD
CONSTRAINT [PK_ta] PRIMARY KEY CLUSTERED
(
[a],
[b]
) ON [PRIMARY]
GO
insert ta select
'001','AB01','sewerw' union select
'001','AB02','FWREEW' union select
'002','AB03','FWEWRWE' union select
'002','AB04','FFWERWE' select * from ta
insert ta select '002','AB01','rwerew'
select * from ta
drop table ta