3.3w+
社区成员
如何返回两个参数值?
我在.net中要返回一个表中取得的两个或更多的数据参数,这样写不知对否?
CREATE PROCEDURE [dbo].[ProvisionMOKey] @TaskNumber varchar(50) output,@MOKey varchar(50) output
AS
--declare @sqlstr varchar(200)
set nocount on
select top 1 @TaskNumber = TaskNumber, @MOKey = MOKey from upline where gatewayhd = @gatewayHD and ContentKey = 1 ORDER BY GatewayHD DESC, TailNumberType, LEN(TailNumber) DESC, ContentKeyType, LEN(ContentKey) DESC
set nocount off
GO
有可能数据集取不到,返回的值是否为空?
CREATE PROCEDURE [dbo].[ProvisionMOKey] @TaskNumber varchar(50) output,@MOKey varchar(50) output
AS
--declare @sqlstr varchar(200)
set nocount on
select top 1 @TaskNumber = TaskNumber, @MOKey = MOKey from upline where gatewayhd = @gatewayHD and ContentKey = 1 ORDER BY GatewayHD DESC, TailNumberType, LEN(TailNumber) DESC, ContentKeyType, LEN(ContentKey) DESC
set nocount off
GO
有可能数据集取不到,返回的值是否为空?
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
hbwhwanghua 2004-09-12
这样是可以的，
也可以直接通过输出结果集的形式得到你要的参数，如：
CREATE PROCEDURE [dbo].[ProvisionMOKey] @gatewayHD AS
--declare @sqlstr varchar(200)
set nocount on
select top 1 TaskNumber, MOKey from upline where gatewayhd = @gatewayHD and ContentKey = 1 ORDER BY GatewayHD DESC, TailNumberType, LEN(TailNumber) DESC, ContentKeyType, LEN(ContentKey) DESC
set nocount off
GO
也可以直接通过输出结果集的形式得到你要的参数，如：
CREATE PROCEDURE [dbo].[ProvisionMOKey] @gatewayHD AS
--declare @sqlstr varchar(200)
set nocount on
select top 1 TaskNumber, MOKey from upline where gatewayhd = @gatewayHD and ContentKey = 1 ORDER BY GatewayHD DESC, TailNumberType, LEN(TailNumber) DESC, ContentKeyType, LEN(ContentKey) DESC
set nocount off
GO
叶子哟 2004-09-12
为何我在查询分析器中直接执行Provision,告诉我没有输入参数TaskNumber,MOKey?
