Добавил:
nyan
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:Oracle - MS Server / 8 / trigDelMod
.txt CREATE TRIGGER trigDelStud ON dbo.Operation
AFTER INSERT
AS
UPDATE dbo.Student SET NORR = NORR+1 WHERE dbo.Student.StudId = (SELECT inserted.StudId FROM inserted);
DELETE FROM dbo.Student WHERE dbo.Student.StudId = (SELECT inserted.StudId FROM inserted)AND dbo.Student.NORR=5;
AFTER INSERT
AS
UPDATE dbo.Student SET NORR = NORR+1 WHERE dbo.Student.StudId = (SELECT inserted.StudId FROM inserted);
DELETE FROM dbo.Student WHERE dbo.Student.StudId = (SELECT inserted.StudId FROM inserted)AND dbo.Student.NORR=5;
Соседние файлы в папке 8