带参数的存储过程
一、作为输入参数的存储过程
if object_ID('TEST''P') IS NOT NULL
DROP PROC TEST
GO
CREATE PROC TEST
@a INT,@b INT
AS
SELECT @a+@b
GO
EXEC TEST 12,13
(或者:EXEC TEST @a=12,@b=13)
结果:25
二、含有输出参数的存储过程
if object_ID('TEST','P') IS NOT NULL
DROP PROC TEST
GO
CREATE PROC TEST
@a INT,@b INT,@c int output
AS
set @c=@a+@b
GO
DECLARE @TEMP INT
EXEC TEST 12,13,@TEMP OUTPUT
或者:(EXEC TEST @a=12,@b=13,@c=@TEMP OUTPUT)
SELECT @TEMP
结果:25