sql进制之间的转换

-----二进制转换十进制-----------------
select sum(data1)
from (  select substring('11011', number, 
1)*power(2,len('11011')-number)data1 
          from (select number from master.dbo.spt_values where type='p')K
          where number <= len('11011')
      ) L
结果：
27
-----八进制转换十进制-----------------
select sum(data1)
from (  select substring('1234567', number, 1)*power(8,len('1234567')-number)data1 
       from (select number from master.dbo.spt_values where type='p')K
       where number <= len('1234567')
     ) L
结果：
342391
-----十六进制转换十进制-----------------
select sum(data1)
from (   select case upper(substring('4eb7', number, 1)) when 'A' then 10 
                                                    when 'B' then 11
                                                    when 'C' then 12