2018-06-25 19:22:55 +02:00
|
|
|
CREATE TRIGGER modyfikacjeUczniowie
|
|
|
|
ON Uczniowie
|
|
|
|
AFTER INSERT, UPDATE, DELETE
|
|
|
|
AS
|
|
|
|
PRINT 'Dodani Uczniowie:'
|
|
|
|
SELECT * FROM INSERTED
|
|
|
|
PRINT 'Usuniêci uczniowie:'
|
|
|
|
SELECT * FROM DELETED
|
|
|
|
PRINT 'Zaaktualizowanych wierszy: ' + STR(@@rowcount);
|
|
|
|
GO
|
|
|
|
|
|
|
|
CREATE TRIGGER modyfikacjeNauczyciele
|
|
|
|
ON Nauczyciele
|
|
|
|
AFTER INSERT, UPDATE, DELETE
|
|
|
|
AS
|
|
|
|
PRINT 'Dodani Nauczyciele:'
|
|
|
|
SELECT * FROM INSERTED
|
|
|
|
PRINT 'Usuniêci Nauczyciele:'
|
|
|
|
SELECT * FROM DELETED
|
|
|
|
PRINT 'Zaaktualizowanych wierszy: ' + STR(@@rowcount);
|
|
|
|
GO
|
|
|
|
|
|
|
|
CREATE TRIGGER modyfikacjeKontakty
|
|
|
|
ON Kontakty
|
|
|
|
AFTER INSERT, UPDATE, DELETE
|
|
|
|
AS
|
|
|
|
PRINT 'Dodane Kontakty:'
|
|
|
|
SELECT * FROM INSERTED
|
|
|
|
PRINT 'Usuniête Kontakty:'
|
|
|
|
SELECT * FROM DELETED
|
|
|
|
PRINT 'Zaaktualizowanych wierszy: ' + STR(@@rowcount);
|
|
|
|
GO
|
|
|
|
|
|
|
|
CREATE TRIGGER modyfikacjeLekcje
|
|
|
|
ON Lekcje
|
|
|
|
AFTER INSERT, UPDATE, DELETE
|
|
|
|
AS
|
|
|
|
PRINT 'Dodane Lekcje:'
|
|
|
|
SELECT * FROM INSERTED
|
|
|
|
PRINT 'Usuniête Lekcje:'
|
|
|
|
SELECT * FROM DELETED
|
|
|
|
PRINT 'Zaaktualizowanych wierszy: ' + STR(@@rowcount);
|
|
|
|
GO
|
|
|
|
|
|
|
|
CREATE TRIGGER Usuwanie
|
|
|
|
ON UczniowieNaLekcji
|
|
|
|
INSTEAD OF DELETE
|
|
|
|
AS
|
|
|
|
PRINT 'Próbowałeś usunać wiersze:';
|
|
|
|
SELECT * FROM DELETED;
|
|
|
|
PRINT 'Działanie zabronione';
|
2018-06-25 19:07:35 +02:00
|
|
|
GO
|