INSERT INTO [onlineexam].[dbo].[empwithcontact]
([id]
，[名称]
，[地址]，[4thcolumnname]

SELECT [id]
，[名称]
，[地址]，''0000''
FROM [onlineexam].[dbo].[emp]

INSERT INTO [onlineexam].[dbo].[empwithcontact]
([id]
,[name]
,[address],[4thcolumnname]

SELECT [id]
,[name]
,[address],''0000''
FROM [onlineexam].[dbo].[emp]

尝试一下.

Try this.

INSERT INTO [onlineexam].[dbo].[empwithcontact]
           ([id]
           ,[name]
           ,[address],
           ,[4th_column_name])
 
SELECT  [id]
       ,[name]
       ,[address]
       ,'0000'
FROM [onlineexam].[dbo].[emp]