sql server 2000数据移植

insert into q_wldw (
           dwdm,
           dwname,
           zgj,
           dwxz,  
           dwlx,  
           qcye,  
           bank,  
           endjjnygr,  
           endjjnydw,  
           endjjnycz,  
           wdh,  
           khrq  
        
)
select a,b,'00','01','00',c,'000','199501','199501','199501','00','1995-01-01'
from a_dwxx;

原文地址:https://www.cnblogs.com/mingtian521/p/3412742.html