存储过程：根据部门编号，返回该部门的员工总数，男员工数，女员工数

好的，下面是根据部门编号返回该部门的员工总数、男员工数和女员工数的存储过程示例：

CREATE PROCEDURE count_employees
    @dept_id INT
AS
BEGIN
    -- 返回该部门员工总数
    DECLARE @total_employees INT;
    SELECT @total_employees = COUNT(*) FROM employees WHERE department_id = @dept_id;
    SELECT @total_employees AS total_employees;

    -- 返回该部门男员工数
    DECLARE @male_employees INT;
    SELECT @male_employees = COUNT(*) FROM employees WHERE gender = 'M' AND department_id = @dept_id;
    SELECT @male_employees AS male_employees;

    -- 返回该部门女员工数
    DECLARE @female_employees INT;
    SELECT @female_employees = COUNT(*) FROM employees WHERE gender = 'F' AND department_id = @dept_id;
    SELECT @female_employees AS female_employees;
END;

当你执行这个存储过程时，它将返回三个结果集，分别是该部门的员工总数、男员工数和女员工数。你可以使用你的编程语言连接到数据库，并调用这个存储过程来获取这些数据。注意，这里用了 @dept_id 参数来指定部门编号，你需要在执行存储过程时传入该参数的值。