如何在存储过程中使用多个select sum()查询

CREATE PROCEDURE GetSumValues
AS
BEGIN
    -- 存储过程的逻辑代码
END

CREATE PROCEDURE GetSumValues
AS
BEGIN
    DECLARE @sum1 INT
    DECLARE @sum2 INT
    
    -- 存储过程的逻辑代码
END

CREATE PROCEDURE GetSumValues
AS
BEGIN
    DECLARE @sum1 INT
    DECLARE @sum2 INT
    
    -- 查询1
    SELECT @sum1 = SUM(column1) FROM table1
    
    -- 查询2
    SELECT @sum2 = SUM(column2) FROM table2
    
    -- 存储过程的逻辑代码
END

CREATE PROCEDURE GetSumValues
AS
BEGIN
    DECLARE @sum1 INT
    DECLARE @sum2 INT
    DECLARE @totalSum INT
    
    -- 查询1
    SELECT @sum1 = SUM(column1) FROM table1
    
    -- 查询2
    SELECT @sum2 = SUM(column2) FROM table2
    
    -- 计算总和
    SET @totalSum = @sum1 + @sum2
    
    -- 输出结果
    SELECT @totalSum AS TotalSum
END