Login
Вопрос по SQL Server 2000 и foreign key
210 просмотров
Перейти к просмотру всей ветки
in Antwort toptop 19.01.07 15:52
А если все таки тригерры для главных таблиц для реагирования на стрирание и обновление строчек примерно такого содержания?
CREATE TRIGGER [Update_FunctionProps] ON [dbo].[Functions]
FOR UPDATE
AS
DECLARE @orig_id nvarchar(50), @new_id nvarchar (50)
SELECT @orig_id= FunctionID from deleted
SELECT @new_id = FunctionID from inserted
if( @orig_id<>@new_id)
BEGIN
UPDATE FunctionProperties
SET FunctionProperties.FunctionID= @new_id
where FunctionID IN(select FunctionID from deleted)
END
CREATE TRIGGER [DELETE_ID] ON [dbo].[Functions]
FOR DELETE
AS
DELETE
FROM [FunctionProperties]
where [FunctionProperties].FunctionID IN (SELECT FunctionID FROM Deleted)
CREATE TRIGGER [Update_FunctionProps] ON [dbo].[Functions]
FOR UPDATE
AS
DECLARE @orig_id nvarchar(50), @new_id nvarchar (50)
SELECT @orig_id= FunctionID from deleted
SELECT @new_id = FunctionID from inserted
if( @orig_id<>@new_id)
BEGIN
UPDATE FunctionProperties
SET FunctionProperties.FunctionID= @new_id
where FunctionID IN(select FunctionID from deleted)
END
CREATE TRIGGER [DELETE_ID] ON [dbo].[Functions]
FOR DELETE
AS
DELETE
FROM [FunctionProperties]
where [FunctionProperties].FunctionID IN (SELECT FunctionID FROM Deleted)
стойте там и слушайте сюда, именно отсюда будет проистекать