/*进制转换为八进制
*/
CREATE FUNCTION BigInt2HexStr(@value BIGINT)
RETURNS VARCHAR(50)
AS
BEGIN
DECLARE @seq CHAR(2)
DECLARE @result VARCHAR(50)
DECLARE @digit CHAR(1)
SET @seq = '0123456789ABCDEF'
--求十进制的@value除以的余数,找到余数对应十六进制的值
SET @result = SUBSTRING(@seq, (@value%2)+1, 1)
WHILE @value > 0
BEGIN
SET @digit = SUBSTRING(@seq, ((@value/2)%2)+1, 1)
SET @value = @value/2
IF @value <> 0
SET @result = @digit + @result
END
RETURN @result
END