如何从存储过程返回多个值到.net ?

Question

我的存储过程需要返回5个不同的值，并希望在。net中使用这些值。存储过程

CREATE PROCEDURE GET_NAME
(
@COUNT INT
)
AS
BEGIN
SET NOCOUNT ON;
DECLARE NAME1 AS VARCHAR(100)
DECLARE NAME2 AS VARCHAR(100)
DECLARE NAME3 AS VARCHAR(100)
SET @NAME1 = (SELECT DRIVER FROM TABLE1 WHERE @COUNT = 10)
SET @NAME2 = (SELECT DRIVER FROM TABLE2 WHERE @COUNT = 10)
SET @NAME3 = (SELECT DRIVER FROM TABLE3 WHERE @COUNT = 10)

SELECT @NAME1
SELECT @NAME2
SELECT @NAME3
END

现在在。net，我知道ExecuteDataset函数可以用来检索多个数据，但我不知道如何进入三个不同的变量作为存储过程返回3个不同的输出。我需要的期望输出是。net变量存储来自sp的值。

如果有人知道，请帮助我。谢谢你

Answer 1

CREATE PROCEDURE GET_NAME
@COUNT INT,
@NAME1 VARCHAR(100) OUTPUT,
@NAME2 VARCHAR(100) OUTPUT,
@NAME3 VARCHAR(100) OUTPUT
AS
BEGIN
SET NOCOUNT ON;

SET @NAME1 = (SELECT DRIVER FROM TABLE1 WHERE @COUNT = 10)
SET @NAME2 = (SELECT DRIVER FROM TABLE2 WHERE @COUNT = 10)
SET @NAME3 = (SELECT DRIVER FROM TABLE3 WHERE @COUNT = 10)

END