Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --Utworz wyzwalacz, ktory po zmodyfikowaniu placy minimalnej zmieni place kazdemu pracownikowi o taka wartosc
- -- o jaka zmienila sie placa minimalna dla jego stanowiska. Napisz rowniez polecenie uruchamiajace wyzwalacz
- DROP TRIGGER wyzwalacz
- GO
- CREATE TRIGGER wyzwalacz
- ON jobs
- AFTER UPDATE
- AS
- DECLARE @nrPracy VARCHAR(20) = (SELECT job_id FROM inserted)
- DECLARE @staraPlaca INT = (SELECT j.min_salary FROM jobs j WHERE j.job_id = @nrPracy)
- DECLARE @nowaPlaca INT = (SELECT min_salary FROM inserted)
- PRINT @staraPlaca
- PRINT @nowaPlaca
- IF(@staraPlaca <> @nowaPlaca)
- BEGIN
- PRINT 'kurwa'
- DECLARE @delta INT = abs(@nowaPlaca - @staraPlaca)
- UPDATE employees SET salary = salary + @delta
- WHERE employees.job_id = @nrPracy
- END
- GO
- UPDATE jobs SET min_salary = 2900 WHERE job_id='SH_CLERK'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement