SQL-ejemplos/Update_Employee.sql at main · dcucoch/SQL-ejemplos · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
CREATE PROCEDURE UpdateEmployeeSalary
    @EmployeeID INT,     -- ID del empleado
    @NewSalary DECIMAL(10, 2) -- Nuevo salario
AS
BEGIN
    SET NOCOUNT ON;

    BEGIN TRY
        BEGIN TRANSACTION;

        -- Validar que el salario sea positivo
        IF @NewSalary <= 0
        BEGIN
            THROW 50004, 'Salary must be greater than 0.', 1;
        END

        -- Actualizar el salario del empleado
        UPDATE Employees
        SET Salary = @NewSalary
        WHERE EmployeeID = @EmployeeID;

        PRINT 'Salary updated successfully.';

        COMMIT TRANSACTION;
    END TRY
    BEGIN CATCH
        ROLLBACK TRANSACTION;
        THROW;
    END CATCH
END;