Question

求教：编写存储过程

编写存储过程。
1， spGetEmployeesInfoByID，从员工表中查询某一工号的员工信息。参数：@EmpID
Creat proc spGetEmployeesInfoByID
@EmpID nchar(10)
As
Select * from Employees where [工号]=@EmpID
2，spGetEmployeesCountOfADepart，获取某一部门的员工人数。参数：@DepartId,@Count
3，spGetLeaveInfoOfADepartByTime，获取某一部门的所有员工某一时间段的请假信息。参数：@DepartId,@StartDate,@EndDate
4，spSetADepartmentManager，设置一个员工为某一部门的主管。参数:@DepartId,@EmpID
第一，二题已经解决

Answer 1

Creat proc spGetEmployeesInfoByID
@DepartID nchar(10),@startdate,@enddate
As
Select * from Employees where [部门ID]=@DepartID and [开始日期] between @startdate and @enddate

Answer 2

create proc pe_show
@departid number,--部门编号
@StartDate smalldatetime,
@EndDate smalldatetime
select * from 表名
where 部门=@departid
and 时间字段>@StartDate and 时间字段< @EndDate