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

来源：互联网发布：天际网络编辑：程序博客网时间：2024/04/28 22:55

Create PROC [dbo].[sp_Test1](@Number VarChar(10),@Result Int OutPut)  Asset nocount onBEGIN---定义变量------------------------------------------------Declare @Sum Int--------------------------------------------------------------初始变量-----------------------------------------------------------------------------------------------------------Set @Result = 0Set @Number = LTrim(RTrim(@Number))If Isnull(@Number, '') = '' ReturnSet @Sum = Cast(SubString(@Number, 1, 1) as Int) +  Cast(SubString(@Number, 2, 1) as Int)+  Cast(SubString(@Number, 3, 1) as Int)+  Cast(SubString(@Number, 4, 1) as Int)+  Cast(SubString(@Number, 5, 1) as Int)+  Cast(SubString(@Number, 6, 1) as Int)+  Cast(SubString(@Number, 7, 1) as Int)+  Cast(SubString(@Number, 8, 1) as Int)Set @Result = Cast(Right(Cast(@Sum as VarChar), 1) as Int)Return @ResultEnd

DECLARE @Number VarChar(10)DECLARE @Result intEXEC [sp_OrderInfoMakeCheckDigit] '420',@Result outputselect @Result