接受多个Id值的T-SQL存储过程

CREATE PROCEDURE GetSumOfIds
    @Ids NVARCHAR(MAX)
AS
BEGIN
    DECLARE @IdList TABLE (Id INT)
    DECLARE @Id INT
    DECLARE @Pos INT = 1

    WHILE @Pos > 0
    BEGIN
        SET @Pos = CHARINDEX(',', @Ids, @Pos)
        IF @Pos > 0
        BEGIN
            SET @Id = CONVERT(INT, SUBSTRING(@Ids, 1, @Pos - 1))
            INSERT INTO @IdList (Id) VALUES (@Id)
            SET @Ids = SUBSTRING(@Ids, @Pos + 1, LEN(@Ids) - @Pos)
        END
        ELSE
        BEGIN
            SET @Id = CONVERT(INT, @Ids)
            INSERT INTO @IdList (Id) VALUES (@Id)
        END
    END

    SELECT SUM(Id) AS Total FROM @IdList
END