如何在主键列中插入重复值？

Question

新手上路，请多包涵

我有一个第一列有主键的表，但是当我看到这个表的可用数据时，我发现重复的记录包括主键数据。我想知道怎么可能？ SQL Server 2008 中的主列是否有重复数据？

         SET ANSI_NULLS ON
        GO

        SET QUOTED_IDENTIFIER ON
        GO

        SET ANSI_PADDING ON
        GO

        CREATE TABLE [dbo].[DemoTbl](
            [ProcedureId] [int] NOT NULL,
            [ProcedureName] [nvarchar](100) NOT NULL,
            [VersionNo] [char](5) NULL,
            [PublishDate] [datetime] NULL,
            [PublishUser] [varchar](50) NULL,

            [SpecialtyId] [int] NOT NULL,
            [ProcedureNumber] [varchar](20) NULL,
            [PowerpointName] [nvarchar](100) NULL,
            [Duration] [int] NOT NULL,

            [LanguageId] [int] NOT NULL,

            [TierId] [smallint] NOT NULL,
            [PrintPdf] [bit] NULL,
            [PresentationModeId] [tinyint] NULL,
         CONSTRAINT [pk_DemoTbl] PRIMARY KEY CLUSTERED
        (
            [ProcedureId] ASC,
            [LanguageId] 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

        SET ANSI_PADDING OFF
        GO

        ALTER TABLE [dbo].[DemoTbl]  WITH CHECK ADD FOREIGN KEY([PresentationModeId])
        REFERENCES [dbo].[DemoTbl] ([PresentationModeId])
        GO

        ALTER TABLE [dbo].[DemoTbl]  WITH CHECK ADD  CONSTRAINT [FK_DemoTbl_Specialty] FOREIGN KEY([SpecialtyId])
        REFERENCES [dbo].[Specialty] ([SpecialtyId])
        GO

        ALTER TABLE [dbo].[DemoTbl] CHECK CONSTRAINT [FK_DemoTbl_Specialty]
        GO

        ALTER TABLE [dbo].[DemoTbl]  WITH CHECK ADD  CONSTRAINT [FK_DemoTbl_TierMaster] FOREIGN KEY([TierId])
        REFERENCES [dbo].[TierMaster] ([TierId])
        GO

        ALTER TABLE [dbo].[DemoTbl] CHECK CONSTRAINT [FK_DemoTbl_TierMaster]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF_DemoTbl_CreationDate]  DEFAULT (getdate()) FOR [CreationDate]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF_DemoTbl_ModifiedDate]  DEFAULT (getdate()) FOR [ModifiedDate]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF_DemoTbl_IsActive]  DEFAULT ((1)) FOR [IsActive]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF_DemoTbl_LanguageId]  DEFAULT ((1)) FOR [LanguageId]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF_DemoTbl_ManageContent]  DEFAULT ('false') FOR [ManageContent]
        GO

        ALTER TABLE [dbo].[DemoTbl] ADD  CONSTRAINT [DF__Procedure__Print__1B14C01D]  DEFAULT ((1)) FOR [PrintPdf]
        GO