[MSSQL] 프로시저 생성 / 실행

 

CREATE PROC [dbo].[프로시저명]
      @PARAM1         VARCHAR(10)
    , @RESULT         NVARCHAR(255) OUTPUT -- 결과
AS
BEGIN
    SET NOCOUNT ON

	DECLARE @VALUE01   VARCHAR(8)
	DECLARE @VALUE02   INT
	DECLARE @VALUE03   NVARCHAR(20)

	BEGIN TRAN

	BEGIN TRY
	
        프로시저 내용

        SELECT @RESULT = 'S'

        COMMIT

	END TRY

    BEGIN CATCH

		ROLLBACK

        SELECT @RESULT = ERROR_MESSAGE()

    END CATCH

END

BEGIN 

DECLARE @RESULT NVARCHAR(255)


EXEC DBO.PRC_RETURN_SALS_WR_PRC_H2 '1', @RESULT OUTPUT

SELECT @RESULT

END