编辑:说三道四文库 发布时间:2018-04-24 04:43
HTML文档下载
WORD文档下载
PDF文档下载
如何测试返回参数的存储过程。要测试output参数的值
比如下面
alter proc it_Customer_orders_Print_PI
@cust_num nvarchar(8),
@message nvarchar(50) output
as
declare @i int
select @i=sum(Amt) from it_aroutst where cust_num =@cust_num
if @i>0
set @message=N'error'
else
set @message=N'ok'
declare @cust_num nvarchar(8)
declare @message nvarchar(50)
exec it_Customer_orders_Print_PI @cust_num ,@message output
declare @msg nvarchar(50)
exec it_Customer_orders_Print_PI '',@msg output
select @msg
楼上正解
declare @message nvarchar(50)
exec it_Customer_orders_Print_PI 'A1234' ,@message output