--16进制to10进制度,看看邹老大写的. 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
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