입력매개변수, 출력매개변수가 있는 저장프로시져

예)

** 1개

use sqlDB;

GO

CREATE PROCEDURE USP_USER1

@userName NVARCHAR(10)

AS

 SELECT * FROM USERTBL WHERE NAME = @userName ;

---------------------------------------------------------------------

실행)

exec usp_users1 'ㅌㅌㅌㅌ';

** 2개

CREATE PROCEDURE USP_USER2

@userBirth      INT,

@userHeight    INT

AS

 SELECT * FROM USERTBL 

  WHERE birthYear > @userBirth AND height > @userHeight;

-----------------------------------------------------------------

실행)

EXEC USP_USER2 1980, 180;

** 출력매개변수 사용시

CREATE PROCEDURE USP_USER4

@txtValue        NCHAR(10),

@outValue       INT OUTPUT

AS

INSERT INTO TESTTBL VALUES ( @txtValue );

SELECT @outValue = IDENT_CURRENT('testTbl');

-- 테이블의 identity값