存储过程传参

   declare @Result int
   exec dbo.sp_UseJCoin @memberid,@ordid,@ordbodyno,@UseQty,@Result output;

 

注意调用时也要加 output ，不然程序不报错，但是结果却没有写进去

 

 

ALTER PROCEDURE [dbo].[sp_UseJCoin]
@memberid nvarchar(50)=null,
@ordid nvarchar(15)=null,
@ordbodyno int=null,
@UseQty int,
@Result int output
AS