我的存盤程序需要回傳 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 的值。
如果有人知道，請幫助我。謝謝
uj5u.com熱心網友回復：
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
轉載請註明出處，本文鏈接：https://www.uj5u.com/ruanti/464852.html
下一篇：子字串長度不能小于零