sql2008 点击表insert时插入其他表数据提示如下错误


代码如下：
INSERT INTO [ExamV2.0].[dbo].[GSys_Doctors]
           ([CD_SerialCode]
           ,[CD_DoctorName]
           ,[CD_Gender]
           ,[CD_JobTitle]
           ,[CD_SeniorityCode]
           ,[CD_PracticeCode]
           ,[CD_MedicCode]
           ,[CD_IndentityCode]
           ,[CD_CatalogCode]
           ,[CD_State])
     VALUES
       [cmda_drems].[dbo].[GSys_Doctors]        
           ([CD_SerialCode]
           ,[CD_DoctorName]
           ,[CD_Gender]
             ,[CD_JobTitle]
            , '1111111'
            ,'1111111'
           ,[CD_MedicCode]
           ,[CD_IndentityCode]           
             ,[CD_MedicSort] 
             ,'1')
GO

------解决方案--------------------
那就要改成这样

INSERT  INTO [ExamV2.0].[dbo].[GSys_Doctors] 

        ( [CD_SerialCode] , 

          [CD_DoctorName] , 

          [CD_Gender] , 

          [CD_JobTitle] , 

          [CD_SeniorityCode] , 

          [CD_PracticeCode] , 

          [CD_MedicCode] , 

          [CD_IndentityCode] , 

          [CD_CatalogCode] , 

          [CD_State] 

        ) 

select  [CD_SerialCode] , 

        &nbs