将数字转换为字母 [英] Convert a number to letters

问题描述

给定一个数字，你如何将其转换为字母?

Given a number, how do you convert that to letters?

推荐答案

您可以将现有逻辑转换为 t-sql 标量函数，如下所示:

You can just translate your existing logic into a t-sql scalar function, like so:

CREATE FUNCTION dbo.fnColumnNameFromIndex(@i int)
RETURNS varchar(3)
AS
BEGIN
DECLARE @dividend int, @letters varchar(3), @modulo int
    SET @dividend = @i
    SET @letters = ''

    WHILE @dividend > 0
    BEGIN
        SET @modulo = (@dividend - 1) % 26
        SET @letters = CHAR(65 + @modulo) + @letters
        SET @dividend = CONVERT(int, (@dividend - @modulo) / 26 )
    END

    RETURN @letters;
END
GO

这样称呼它:

选择 dbo.fnColumnNameFromIndex(2000)

SELECT dbo.fnColumnNameFromIndex(2000)

...诚然没有设置逻辑，但我不认为这是一个设置逻辑问题.

...admittedly not set logic, but I don't see this as a set logic problem.

这篇关于将数字转换为字母的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！