返回首页

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' 

回答

评论会员:manoharank5 时间:2012/02/05
。的INSERT INTO [onlineexam] [DBO] [empwithcontact]
([ID]
 60; [名]
[地址],[4thcolumnname]

选择[ID]
[名]
[地址],'0000'
从[onlineexam] [DBO] [EMP]
评论会员:游客 时间:2012/02/05
|T|oniyo|Jackson
试试这个
{C}