在数据库中根据身份证号算出生日期
摘要：
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 悉野 阅读(767) 评论(0) 推荐(0) 编辑