两表之间拷数据

 

格式：

insert into  hzjc.dbo.b_gjb(  username)
select username
from 
 ff.dbo.gjb

 

 

insert into  hzjc.dbo.b_gjb(InnerID,hzjc.dbo.b_gjb.Number,hzjc.dbo.b_gjb.Name,hzjc.dbo.b_gjb.zwmc,hzjc.dbo.b_gjb.ywmc,hzjc.dbo.b_gjb.Description,dlqy,hzjc.dbo.b_gjb.sc)
select 100,gjbm,gjjc,zwmc,ywmc,bz,dlqy,sc 
from
 gjb