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

原创于 2013-08-19 17:15:23 发布 · 2.1k 阅读

0 ·

CC 4.0 BY-SA版权

Sql 专栏收录该内容

19 篇文章

订阅专栏

本文介绍了一个使用SQL存储过程实现的校验码生成方法。该存储过程接受一个包含数字的字符串作为输入，并通过将每个字符转换为整数并求和的方式计算总和，最终返回总和的个位数作为校验码。此方法适用于需要简单校验码的场景。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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, 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 @Result
End

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