在SQL Server 2008中生成字母数字序列

WITH CTE AS (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNum
    FROM sys.columns
)
SELECT RowNum
FROM CTE

WITH CTE AS (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNum
    FROM sys.columns
)
SELECT CHAR(64 + RowNum) AS Letter
FROM CTE

WITH CTE AS (
    SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS RowNum
    FROM sys.columns
)
SELECT CONCAT(CHAR(64 + RowNum), RowNum) AS AlphaNumeric
FROM CTE