复制SELECT update userinfo set Useducation = + CASE WHEN [现文化程度] IS NULLTHEN ELSE [现文化程度] END + CASEWHEN [技术等级] IS NULLTHEN ELSE ,利用 Usskilllevel = + [技术等级] END + + CASEWHEN [加入党派日期] IS NULLTHEN ELSE , Usdangtuantime = to_date(+ CONVERT(VARCHAR(12), [加入党派日期], 110)+ ,mm-dd-yyyy) END + CASEWHEN [入路工作日期] IS NULLTHEN ELSE , Usinputtime = to_date(+ CONVERT(VARCHAR(12), [入路工作日期], 110)+ ,mm-dd-yyyy) END + CASEWHEN [出生日期] IS NULLTHEN ELSE , Usbirthdate = to_date(+ CONVERT(VARCHAR(12), [出生日期], 110)+,mm-dd-yyyy) END + where Uscardid =+ [身份证号] + ; FROM OPENDATASOURCE(Microsoft.Jet.OLEDB.4.0, Data Source=D:\gongren.xls;Extended Properties=Excel 8.0)...[Sheet1$] 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27. |
喜欢
讨厌