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