[MSSQL] Procedure 생성, 수정, 실행, 삭제

Procedure 생성

CREATE PROCEDURE SP_TEST
@AA VARCHAR(10),
@BB VARCHAR(10),
@CC VARCHAR(10) OUTPUT
AS
    DECLARE @RET VARCHAR;
    SET @RET = '33';
    SET @CC = @AA + @BB + @RET;
GO

Procedure 수정

ALTER PROCEDURE ...

Procedure 실행

DECLARE @RET VARCHAR(10);
EXEC SP_TEST @AA = '11', @BB = '22', @CC = @RET OUTPUT;
PRINT @RET;

Procedure 삭제

DROP PROCEDURE SP_TEST;