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.
|
|
|
|
|
USE Study
|
|
|
|
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
CREATE PROC EMP_PRO
|
|
|
|
|
|
AS
|
|
|
|
|
|
SELECT ENAME, JOB, SALARY
|
|
|
|
|
|
FROM EMPLOYEE
|
|
|
|
|
|
WHERE ENO = 109
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
EXEC EMP_PRO
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD>
|
|
|
|
|
|
ALTER PROC EMP_PRO
|
|
|
|
|
|
AS
|
|
|
|
|
|
SELECT ENAME, JOB, SALARY
|
|
|
|
|
|
FROM EMPLOYEE
|
|
|
|
|
|
WHERE ENO = 110
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
EXEC EMP_PRO
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD>Է<EFBFBD> <EFBFBD>Ű<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> Ȱ<EFBFBD><EFBFBD>
|
|
|
|
|
|
CREATE PROC EMP_PRO_PARAM
|
|
|
|
|
|
@enumber INT
|
|
|
|
|
|
AS
|
|
|
|
|
|
SELECT ENAME, JOB, SALARY
|
|
|
|
|
|
FROM EMPLOYEE
|
|
|
|
|
|
WHERE ENO = @enumber
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
EXEC EMP_PRO_PARAM 101
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD><EFBFBD> <EFBFBD>Ű<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD> Ȱ<EFBFBD><EFBFBD>
|
|
|
|
|
|
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
|
