sql 3 примера использования хранимых процедур

1. Создание новой записи в базе данных:

CREATE PROCEDURE sp_InsertEmployee
    @FirstName NVARCHAR(50),
    @LastName NVARCHAR(50),
    @DepartmentID INT
AS
BEGIN
    INSERT INTO Employees (FirstName, LastName, DepartmentID)
    VALUES (@FirstName, @LastName, @DepartmentID)
END

2. Обновление данных в базе данных:

CREATE PROCEDURE sp_UpdateEmployee
    @EmployeeID INT,
    @FirstName NVARCHAR(50),
    @LastName NVARCHAR(50),
    @DepartmentID INT
AS
BEGIN
    UPDATE Employees
    SET FirstName = @FirstName, LastName = @LastName, DepartmentID = @DepartmentID
    WHERE EmployeeID = @EmployeeID
END

3. Получение данных из базы данных:

CREATE PROCEDURE sp_GetEmployeesByDepartment
    @DepartmentID INT
AS
BEGIN
    SELECT EmployeeID, FirstName, LastName
    FROM Employees
    WHERE DepartmentID = @DepartmentID
END