USE Study
GO

-- »ý¼º
CREATE PROC EMP_PRO
AS
	SELECT ENAME, JOB, SALARY
	FROM EMPLOYEE
	WHERE ENO = 109

GO
EXEC EMP_PRO

-- ¼öÁ¤
ALTER PROC EMP_PRO
AS
	SELECT ENAME, JOB, SALARY
	FROM EMPLOYEE
	WHERE ENO = 110

GO
EXEC EMP_PRO

-- ÀÔ·Â ¸Å°³º¯¼ö È°¿ë
CREATE PROC EMP_PRO_PARAM
@enumber INT
AS
	SELECT ENAME, JOB, SALARY
	FROM EMPLOYEE
	WHERE ENO = @enumber

GO
EXEC EMP_PRO_PARAM 101

-- Ãâ·Â ¸Å°³º¯¼ö È°¿ë
CREATE PROC EMP_PRO_OUT_PARAM
@did INT,
@avg_sal INT OUTPUT
AS
	SELECT @avg_sal = AVG(SALARY)
	FROM EMPLOYEE
	WHERE EMPLOYEE.DNO = @did

GO
DECLARE @AVG_SALARY INT
EXEC EMP_PRO_OUT_PARAM 30, @AVG_SALARY OUTPUT
SELECT @AVG_SALARY