CREATE TRIGGER sumar
on historial_laboral
for update
as
Declare @Id_historyLab int
Declare @monto float
Declare @neto float
set @Id_historyLab=(select max(Id_historyLab) from historial_laboral)
set @monto = (select salario_neto from historial_laboral where Id_historyLab = @Id_historyLab)
update historial_laboral
set salario_neto= (@monto+1000.0)
where Id_historyLab = @Id_historyLab