如何将多个值返回到具有一个输入参数的sql server的单个输出参数中 [英] how to return morethan one value into a single output parameter of sql server which has one input parameter

问题描述

我的要求是获取由单个供应商执行的TransactionId的列表.为此，我们将如下所示编写quire:

从TransDetails中选择TransactionId形式，其中VendorId = 101;(101是供应商ID的示例)；"

我想使用普通查询的存储过程instad获得相同的结果.

请任何人都可以给我编写用于创建和执行存储过程的代码，以获得上述结果.

在此先感谢您.

Hi,

My requirement is to get list of TransactionIds which are performad by a single Vendor. To get this we will write quire like below:

"select TransactionId form TransDetails where VendorId=101;(101 is example for vendor id);"

I want to get same result using Store Procedure instad of normal query.

Please any one can give me the coding for creating and executing Stored Procedure to get above result.

Thanks in Advance.

推荐答案

首先尝试执行以下操作:

Jst try something like this:

CREATE PROCEDURE OrderSummary @VendorId INT AS
  SELECT TransactionId FROM TransDetails WHERE VendorId=@VendorId;

祝你好运！

good luck!

这篇关于如何将多个值返回到具有一个输入参数的sql server的单个输出参数中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！