在数据库中根据身份证号算出生日期
摘要：update Staff_information setcsny =case when LEN(sfzh)=18 then (substring(sfzh,7,4) +'-'+ substring(sfzh,11,2)+'-'+ substring(sfzh,13,2))when LEN(sfzh)=15 then ('19' + substring(sfzh,7,2) +'-'+ substring(sfzh,9,2)+'-'+ substring(sfzh,11,2))else nullendfrom Staf
阅读全文
posted @ 2011-04-20 15:42
