如何返回两个参数值?

[叶子哟]

我在.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

有可能数据集取不到,返回的值是否为空?

[叶子哟]

为何我在查询分析器中直接执行Provision,告诉我没有输入参数TaskNumber,MOKey?

[hbwhwanghua]

这样是可以的，

也可以直接通过输出结果集的形式得到你要的参数，如：

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