USE Study
GO

-- »ý¼º
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)

-- Å×ÀÌºí ¹Ýȯ ÇÔ¼ö
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)