本文介绍了如何将多个值返回到具有一个输入参数的sql server的单个输出参数中的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我的要求是获取由单个供应商执行的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的单个输出参数中
发布评论