update [表名] set [性別]=(case when (left(right([身份證],2),1) % 2 = 0) then '女' else '男' end ) where len([身份證])=18 and left(right([身份證],2),1)<>'X'
update [表名] set [性別]=(case when (right([身份證],1) % 2 = 0) then '女' else '男' end ) where len([身份證])=15 and right([身份證],1)<>'X'
update [表名] set [出生日期]=(right(left([身份證],10),4)+'-'+right(left([身份證],12),2)+'-'+right(left([身份證],14),2)) where len([身份證])=18
update [表名] set [出生日期]=('19'+right(left([身份證],8),2)+'-'+right(left([身份證],10),2)+'-'+right(left([身份證],12),2)) where len([身份證])=15
update [表名] set [年齡]=year(getdate())-(cast(left([出生日期],4) as int)) where [出生日期]<>''