存储过程return,表示该存储过程执行到当当前return位置,不再向下执行;
存储过程写法:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[test]
(
@ID NUMERIC(10),
@Password numeric(10)
)
AS
BEGIN
return 0;
END
存储过程调用方法:
DECLARE @Code NUMERIC(10);
EXECUTE @Code=dbo.test
1,
2
select @Code
存储过程output返回参数,可以返回多个参数,一下为实例
存储过程写法:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[test]
(
@AA numeric(30),
@RValue varchar(10) output
)
AS
DECLARE @total numeric(8,0)
BEGIN
select @total=count(*) from dbo.Skill where ID=@AA
set @RValue= 'ad';
--return @RValue;
END
调用方法:
declare @i varchar(10)
EXEC [dbo].[test] 1,@i output
select @i
。net 中xml中ibatis调用方法
ibatis 调用
<select id='Test' parameterClass='User' resultClass='int'>
DECLARE @Code numeric(10);
EXECUTE dbo.test
@ID=#ID#,
@Password=#Password#,
@RValue = @Code output;
select @Code
</select>