9eCjfMyT

1USE EMPRESA
2
3IF NOT EXISTS (SELECT * FROM SYS.sysobjects WHERE NAME='HISTORICOSALARIO' AND XTYPE='U')
4BEGIN
5	CREATE TABLE HISTORICOSALARIO(
6	ID INT IDENTITY,
7	EMPNO INT NOT NULL,
8	SALARIOANT INT NOT NULL,
9	SALARIONUEVO INT NOT NULL,
10	FECHA DATE DEFAULT GetDate(),
11	PRIMARY KEY (ID)
12	);
13END;
14
15IF OBJECT_ID ('CambioSalario','TR') IS NOT NULL
16BEGIN
17	DROP TRIGGER CambioSalario
18END
19
20GO
21
22CREATE TRIGGER CambioSalario
23ON EMPLEADOS
24AFTER UPDATE AS
25	if update (salario)
26BEGIN
27	INSERT INTO HISTORICOSALARIO (EMPNO,SALARIOANT,SALARIONUEVO) 
28	(SELECT D.EMPNO, D.SALARIO, I.SALARIO FROM DELETED D, INSERTED I WHERE D.EMPNO=I.EMPNO)
29END;