Создание DELETE триггера на View
Всех приветствую. Пытаюсь сделать триггер на представлении (View), но возникает ошибка.
Мой триггер:
ALTER TRIGGER [dbo].[PersonClients_DELETE_TRIGGER]
ON [dbo].[Clients_View]
INSTEAD OF DELETE
AS
BEGIN
DELETE FROM PersonSet_Client WHERE Id = (SELECT ID FROM PersonSet
WHERE FirstName = (select FirstName from deleted) AND
LastName = (select LastName from deleted))
END
Но возникает проблема:
При удалении данных возникает ошибка:
No rows were deleted. A problem occurred attempting to delete row 9. Error Source: Microsoft. SqlServer. Management. DataTools. Error Message: The row value(s) updated or deleted either do not make the row unique or they alter multiple rows(2 rows). Correct the errors and attempt to delete the row again or press ESC to cancel the change(s). s)
Что с этим можно сделать?