多个字段值都相同,则不允许插入重复的数据

--------------------------------next sql is used for create a  test table, you can create yourself ---------------------------------------------

USE [ACCPTEST]

GO

/****** Object:  Table [dbo].[tUnique]    Script Date: 12/14/2010 10:12:56 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[tUnique](

[ID] [int] IDENTITY(1,1) NOT NULL,

[lastName] [nchar](10) NULL,

[firstName] [nchar](10) NULL,

 CONSTRAINT [PK_tUnique] PRIMARY KEY CLUSTERED 

(

[ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

 CONSTRAINT [myUnique] UNIQUE NONCLUSTERED 

(

[lastName] ASC,

[firstName] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

-----------------------------------------------------add next sql--------------------------------------------------------

1. alter table tUnique add constraint myUnique unique(lastName,firstName);

2. insert into tUnique(lastName,firstName) values ('dayu','liu');