EXCEL 生成SQL语句


--产品
CONCATENATE("(NEWID(),'",A2,"','",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",G2,"','",H2,"','",I2,"','",J2,"','",K2,"','",L2,"','",M2,"','",N2,"','",O2,"','",P2,"',GETDATE(),'0','0','4042');")

--价格
CONCATENATE("(NEWID(),'",A2,"','",B2,"','",C2,"','",D2,"','",E2,"','",F2,"','",G2,"','",H2,"','",I2,"','",J2,"','",K2,"','",L2,"','",M2,"','",N2,"','",O2,"',GETDATE(),'0','0','4042');")

--
CONCATENATE("(NEWID(),'",A2,"','",B2,"','",D2,"','",F2,"','",G2,"','",H2,"','",I2,"','",J2,"','",K2,"','",L2,"','",M2,"','",N2,"','",O2,"','",P2,"','",Q2,"',GETDATE(),'0','0','4042');")

posted @ 2020-01-19 15:42  大脸猫9527  阅读(73)  评论(0)    收藏  举报