可不可以同时输出两个值来
CREATE PROCEDURE dbo.P_Statistics_OverMoney
@Acct_Money FLOAT OUT,
@Card_Money FLOAT OUT
AS
BEGIN
SELECT @Acct_Money=CONVERT(DECIMAL(10,2),SUM(CONVERT(FLOAT,Balance/100000.)))
FROM T_Account
WHERE ExpireDate<GETDATE()
SELECT @Card_Money=CONVERT(DECIMAL(10,2),SUM(CONVERT(FLOAT,Balance/100000.)))
FROM T_Card WHERE ExpireDate<GETDATE()
END
GO
一个存储过程两个SELECT 语句可不可以同时输出两个值来