sql server 中一个数字的总和，而不使用像 while 这样的传统循环 [英] Sum of digits of a number in sql server without using traditional loops like while

问题描述

var1 = 12345
output = 1+2+3+4+5 = 15

我尝试了以下

Declare @var1 int   = 12345,
        @Length int = len(12345)

;with SUMM as 
(
SELECT SUBSTRING(CAST(@var1 AS VARCHAR) ,1,@Length)%10 N
UNION ALL
SELECT SUBSTRING(CAST(@var1 AS VARCHAR) ,1,@Length-1))%10 N
FROM SUMM
WHERE @Length <= len(@var1)
)
SELECT SUM(N) FROM SUMM;

请帮助我用 cte 实现它，欢迎使用传统循环以外的任何其他方法

Please help me with achieving it with cte and any other methods other than traditional looping are welcome

推荐答案

如果有点无意义，这是一个有趣的练习.

It's a fun exercise if a bit pointless.

DECLARE @var1 int   = 12345;

WITH i AS (
    SELECT @var1 / 10 n, @var1 % 10 d

    UNION ALL

    SELECT n / 10, n % 10
    FROM i
    WHERE n > 0
)
SELECT SUM(d)
FROM i;

这篇关于sql server 中一个数字的总和，而不使用像 while 这样的传统循环的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！