摘要：create function [dbo].[inttohex](@i int)returns varchar(15)begin--declare @int--set @i=11259375declare @r varchar(10)set @r=''while @i/16>0beginset @r=(casewhen (@i%16)0 set @r = (casewhen(@i%16)<=9 then convert(varchar(1),@i%16)when (@i%16)<=10 then 'A'when (@i%16)<=11 t 阅读全文