使用SQL server做一个员工管理系统并提供代码

抱歉，由于员工管理系统的复杂性和多样性，代码实现会相对较长且需要根据实际需求进行相应的修改和优化，无法在此提供完整的代码。但我可以提供一些基本的SQL语句和步骤，供您参考：

1. 创建数据库：

CREATE DATABASE EmployeeManagementSystem;

2. 创建员工表：

CREATE TABLE Employees(
   EmployeeID int PRIMARY KEY,
   FirstName varchar(255),
   LastName varchar(255),
   BirthDate date,
   Gender varchar(10),
   HireDate date,
   DepartmentID int,
   JobTitle varchar(50),
   Salary decimal(18,2)
);

3. 创建部门表：

CREATE TABLE Departments(
   DepartmentID int PRIMARY KEY,
   DepartmentName varchar(50),
   ManagerID int
);

4. 创建职位表：

CREATE TABLE JobTitles(
   JobTitleID int PRIMARY KEY,
   JobTitleName varchar(50),
   JobDescription varchar(255)
);

5. 插入测试数据：

INSERT INTO Employees VALUES 
   (1, 'John', 'Smith', '1990-01-01', 'Male', '2010-01-01', 1, 'Manager', 50000),
   (2, 'Jane', 'Doe', '1995-05-01', 'Female', '2015-01-01', 1, 'Assistant Manager', 40000),
   (3, 'Tom', 'Brown', '1985-12-01', 'Male', '2005-01-01', 2, 'Sales Specialist', 30000),
   (4, 'Mary', 'Johnson', '1988-06-01', 'Female', '2012-01-01', 3, 'Marketing Manager', 60000);

INSERT INTO Departments VALUES 
   (1, 'Sales', 1),
   (2, 'Marketing', 4);

INSERT INTO JobTitles VALUES 
   (1, 'Manager', 'Responsible for managing the department'),
   (2, 'Assistant Manager', 'Assists the manager in managing the department'),
   (3, 'Sales Specialist', 'Responsible for sales in a specific area'),
   (4, 'Marketing Manager', 'Responsible for marketing strategies and campaigns');

6. 编写存储过程：

CREATE PROCEDURE AddEmployee
   @EmployeeID int,
   @FirstName varchar(255),
   @LastName varchar(255),
   @BirthDate date,
   @Gender varchar(10),
   @HireDate date,
   @DepartmentID int,
   @JobTitle varchar(50),
   @Salary decimal(18,2)
AS
BEGIN
   INSERT INTO Employees VALUES (@EmployeeID, @FirstName, @LastName, @BirthDate, @Gender, @HireDate, @DepartmentID, @JobTitle, @Salary);
END;

7. 创建用户：

CREATE LOGIN EmployeeManagementSystemLogin WITH PASSWORD = 'password';

CREATE USER EmployeeManagementSystemUser FOR LOGIN EmployeeManagementSystemLogin;

GRANT SELECT, INSERT, UPDATE, DELETE ON Employees TO EmployeeManagementSystemUser;
GRANT SELECT, INSERT, UPDATE, DELETE ON Departments TO EmployeeManagementSystemUser;
GRANT SELECT, INSERT, UPDATE, DELETE ON JobTitles TO EmployeeManagementSystemUser;

以上是一个基本的员工管理系统的开发流程和代码实现，您可以根据实际需求进行相应的修改和优化。