在Sqlserver里获取存储过程返回值和带入参数实例

Create PROC [dbo].[sp_Test1]
(
	@Number VarChar(10),@Result Int OutPut
)
  
As
set nocount on
BEGIN
---定义变量------------------------------------------------
	Declare @Sum Int
-----------------------------------------------------------

---初始变量------------------------------------------------
	
-----------------------------------------------------------
	Set @Result = 0
	Set @Number = LTrim(RTrim(@Number))
	If Isnull(@Number,'') = '' Return
	Set @Sum = Cast(SubString(@Number,1,1) as Int) +
				  Cast(SubString(@Number,2,1) as Int)+
				  Cast(SubString(@Number,3,4,5,6,7,8,1) as Int)
	Set @Result = Cast(Right(Cast(@Sum as VarChar),1) as Int)
	Return @Result
End

?

?

?

DECLARE @Number VarChar(10)
DECLARE @Result int
EXEC [sp_OrderInfoMakeCheckDigit] '420',@Result output
select @Result

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!