SQL SERVER 自定义函数 整数转成指定长度的16进制 转换成指定长度的16进制 不足补0

 1 Create Function IntToHexLength(@Num int,@HxLength int)
 2 returns varchar(16)
 3 as
 4 begin
 5   declare @Mods int,@res varchar(16),@Length int
 6   set @res=‘‘
 7   while @Num <> 0 
 8   begin
 9     set @Mods =@Num % 16
10     if @Mods > 9 
11       set @res = Char(Ascii(‘A‘)+@Mods-10)+@res
12     else 
13       set @res = Cast(@Mods as varchar(4)) + @res
14     set @Num = @Num/16
15   end
16   set @Length=@HxLength-DataLength(@res)
17   if(DataLength(@res)<@HxLength)
18   BEGIN
19       while @Length<>0
20       begin
21       SET @res=‘0‘+@res
22       set @Length=@Length-1
23       end
24   END
25   return @res
26 end