SQL server十进制转换十六进

直接看代码

declare @CountStr varchar(50)
declare @i int --循环值
set @i=20
set @CountStr=''
while @i!=0
begin
 set @CountStr=(select price from Going_LC_contrast where refer=@i%16)+@CountStr
 set @i=@i/16
end
select  @CountStr

Going_LC_contrast 参照表

CREATE TABLE Going_LC_contrast(
price [varchar](50) NULL,
refer INT NULL
)
delete Going_LC_contrast
insert into  Going_LC_contrast(price,refer)VALUES
('0',0),('1',1),('2',2),('3',3),('4',4),('5',5),('6',6),('7',7),('8',8),('9',9),
('A',10),('B',11),('C',12),('D',13),('E',14),('F',15),('G',16),('H',17),('J',18),('K',19),
('L',20),('M',21),('N',22),('P',23),('Q',24),('R',25),('S',26),('T',27),('U',28),('V',29),
('W',30),('X',31),('Y',32),('Z',33)