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] , 
          [CD_DoctorName] , 
          [CD_Gender] ,  
 
          [CD_JobTitle] , 
          '1111111' , 
          '1111111' , 
          [CD_MedicCode] , 
          [CD_IndentityCode] , 
          [CD_MedicSort] , 
          '1'
from  [cmda_drems].[dbo].[GSys_Doctors]

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]
       ,[CD_DoctorName]
       ,[CD_Gender]
       ,[CD_JobTitle]
       ,'1111111'
       ,'1111111'
       ,[CD_MedicCode]
       ,[CD_IndentityCode]           
       ,[CD_MedicSort] 
       ,'1'
from [cmda_drems].[dbo].[GSys_Doctors]