--示例declare @hex varchar(10) set @hex='2c37'--转换处理 declare @i int,@value int select @hex=reverse(@hex),@value=0,@i=0 while @hex>'' select @value=@value +case when left(@hex,1) between '0' and '9' then left(@hex,1) else charindex(left(@hex,1),'abcdef')+9 end*power(16,@i) ,@i=@i+1,@hex=stuff(@hex,1,1,'') select 结果=@value--结果: 11319
set @hex='2c37'--转换处理
declare @i int,@value int
select @hex=reverse(@hex),@value=0,@i=0
while @hex>''
select @value=@value
+case
when left(@hex,1) between '0' and '9'
then left(@hex,1)
else charindex(left(@hex,1),'abcdef')+9
end*power(16,@i)
,@i=@i+1,@hex=stuff(@hex,1,1,'')
select 结果=@value--结果: 11319