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;

posted on 2013-11-07 16:32  明天521  阅读(191)  评论(0编辑  收藏  举报