[MSSQL]将身份证的15位号码升级为18位

最新推荐文章于 2025-05-12 16:10:32 发布

厦门德仔

最新推荐文章于 2025-05-12 16:10:32 发布

阅读量1.3k

点赞数

CC 4.0 BY-SA版权

分类专栏： MSSQL 文章标签： function 测试

本文链接：https://blog.youkuaiyun.com/david_520042/article/details/7256635

MSSQL 专栏收录该内容

307 篇文章 ¥99.90 ¥299.90

订阅专栏

超级会员免费看

创建了一个SQL函数[dbo].[id15to18]，用于将15位的身份证号码转换为18位，通过计算校验码并添加19作为年份前缀。示例中，输入'222222830604321'，返回'222222198306043213'。

go
--创建函数(此函数来自于csdn，作者不详)
create function [dbo].[id15to18] (@id15 char(15)) 
returns char(18)
as 
begin 
declare @id18 char(18)
declare @s1 as integer
declare @s2 as integer
declare @s3 as integer
declare @s4 as integer
declare @s5 as integer
declare @s6 as integer
declare @s7 as integer
declare @s8 as integer
declare @s9 as integer
declare @s10 as integer
declare @s11 as integer
declare @s12 as integer
declare @s13 as integer
declare @s14 as integer
declare @s15 as integer
declare @s16 as integer
declare @s17 as integer
declare @s18 as integer
set @s1=substring(@id15,1,1)
set @s2=substring(@id15,2,1)
set @s3=substring(@id15,3,1)
set @s4=substring(@id15,4,1)
set @s5=substring(@id15,5,1)
set @s6=substring(@id15,6,1)
set

了解本专栏