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 FUNCTION MAX_SAL
|
|
|
|
|
|
(@DNO_PARA INT)
|
|
|
|
|
|
RETURNS INT
|
|
|
|
|
|
AS
|
|
|
|
|
|
BEGIN
|
|
|
|
|
|
|
|
|
|
|
|
DECLARE @MAX_VAL INT
|
|
|
|
|
|
|
|
|
|
|
|
SELECT @MAX_VAL = MAX(SALARY)
|
|
|
|
|
|
FROM EMPLOYEE
|
|
|
|
|
|
WHERE DNO = @DNO_PARA
|
|
|
|
|
|
|
|
|
|
|
|
RETURN @MAX_VAL
|
|
|
|
|
|
|
|
|
|
|
|
END
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
SELECT * FROM EMPLOYEE WHERE SALARY = dbo.MAX_SAL(30)
|
|
|
|
|
|
|
|
|
|
|
|
-- <EFBFBD><EFBFBD><EFBFBD>̺<EFBFBD> <EFBFBD><EFBFBD>ȯ <EFBFBD>Լ<EFBFBD>
|
|
|
|
|
|
CREATE FUNCTION EMP_DEPT
|
|
|
|
|
|
(@dno_para INT)
|
|
|
|
|
|
RETURNS @emp_dep_table TABLE(
|
|
|
|
|
|
EMP_ID INT,
|
|
|
|
|
|
EMP_NAME VARCHAR(20)
|
|
|
|
|
|
)
|
|
|
|
|
|
AS
|
|
|
|
|
|
BEGIN
|
|
|
|
|
|
|
|
|
|
|
|
INSERT INTO @emp_dep_table
|
|
|
|
|
|
SELECT EMPLOYEE.ENO, EMPLOYEE.ENAME
|
|
|
|
|
|
FROM EMPLOYEE
|
|
|
|
|
|
WHERE DNO = @dno_para
|
|
|
|
|
|
|
|
|
|
|
|
RETURN
|
|
|
|
|
|
END
|
|
|
|
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
SELECT * FROM dbo.EMP_DEPT(20)
|
