HII
&
#160; 我有两个表EMP(3 colums)和empwithcontact(4列)。我要复制所有记录从EMP empwithcontact,我想在最后一列插入默认情况下,"0000"。我已经试过这...但错误occoured(近0000不正确的语法)... INSERT INTO [onlineexam].[dbo].[empwithcontact]
([id]
,[name]
,[address]
SELECT [id]
,[name]
,[address]
FROM [onlineexam].[dbo].[emp] ,'0000'