BigIntTo26HexStr

ALTER FUNCTION [dbo].[BigIntTo26HexStr](@Value bigint)

RETURNS varchar(14)--最大值DSQYOMTLWMKGIH=9223372036854775807

AS

BEGIN

    DECLARE @BaseCharSet char(36)

    DECLARE @Result varchar(50)

    DECLARE @Digit char(1)

    SET @Value=@Value

    SET @BaseCharSet='ABCDEFGHIJKLMNOPQRSTUVWXYZ'

    SET @Result=Substring(@BaseCharSet, (@Value % 26) + 1, 1)

    WHILE @Value>25

    BEGIN

        SET @Digit=Substring(@BaseCharSet, ((@Value / 26) % 26) + 1, 1)

        SET @Value=@Value / 26

        SET @Result=@Digit + @Result

    END

    RETURN @Result

END