프로시저 예제

BEGIN
declare
@emp_id NUMERIC
,@cd VARCHAR(30)
,@name VARCHAR(30)

CREATE TABLE #temp (emp_id numeric, cd varchar(30), name varchar(30)) ;

SET @emp_id = 607;
EXEC dbo.is_func_supervisor @emp_id, @emp_id output, @cd output, @name output;

INSERT INTO #temp(emp_id, cd, name) VALUES (@emp_id, @cd, @name);

END;

select * from #temp