sqlserver数据库存储过程怎么写

CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Department NVARCHAR(50)
);

CREATE PROCEDURE GetEmployeesByDepartment
    @Department NVARCHAR(50)
AS
BEGIN
    SELECT * FROM Employees WHERE Department = @Department;
END;

EXEC GetEmployeesByDepartment @Department = 'Sales';

-- 创建Employees表
CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Department NVARCHAR(50)
);

-- 插入示例数据
INSERT INTO Employees (EmployeeID, FirstName, LastName, Department)
VALUES (1, 'John', 'Doe', 'Sales'),
       (2, 'Jane', 'Smith', 'Marketing'),
       (3, 'Mike', 'Johnson', 'Sales');

-- 创建存储过程
CREATE PROCEDURE GetEmployeesByDepartment
    @Department NVARCHAR(50)
AS
BEGIN
    SELECT * FROM Employees WHERE Department = @Department;
END;

-- 执行存储过程
EXEC GetEmployeesByDepartment @Department = 'Sales';