SELECT @dname = Dname from Dept WHERE Deptno=@param_deptno; SELECT @param_empCount= Count(*) FROM Emp WHERE Deptno=@param_deptno; ...