[求助]向通过MSSQL命令 批量更新年龄 Post By:2023/3/29 16:06:00 [只看该作者]
Dim cmd As New SQ\Command
cmd.Connecti
cmd.Com mand Text = "UPD ATE {人员信息表} SET 年龄 = Iif(DATALENGTH(身份证号)<18,(substring(CONVERT(varchar(100), GETDATE(), 23),1,4)-(1900+substring(身份证号,7,2)))-(substring(身份证号,9,4)-format(Getdate(),'%m%d')),(substring(CONVERT(varchar(100), GETDATE(), 23),1,4)-substring(身份证号,7,4))-(substring(身份证号,11,4)-format(Getdate(),'%m%d') )) WHERE 身份证号 is not null AND 身份证号<>''"