Добавил:
nyan
Опубликованный материал нарушает ваши авторские права? Сообщите нам.
Вуз:
Предмет:
Файл:Oracle - MS Server / 8 / trigDelAll
.txt CREATE TRIGGER trigDelAll ON dbo.Student
INSTEAD OF Delete
AS
DECLARE @x int;
SELECT @x=Deleted.StudId from Deleted;
IF EXISTS (SELECT * from dbo.Operation WHERE StudId = @x)
DELETE FROM dbo.Operation WHERE StudId = @x;
DELETE FROM dbo.Student WHERE StudId = @x;
INSTEAD OF Delete
AS
DECLARE @x int;
SELECT @x=Deleted.StudId from Deleted;
IF EXISTS (SELECT * from dbo.Operation WHERE StudId = @x)
DELETE FROM dbo.Operation WHERE StudId = @x;
DELETE FROM dbo.Student WHERE StudId = @x;
Соседние файлы в папке 8