You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
47 lines
635 B
47 lines
635 B
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 |