Is it possible to hang a trigger on a clustered (materialized) view?

O

one__for__one2017-02-27 05:05:18

SQL Server

one__for__one, 2017-02-27 05:05:18

Hello!
View from several tables, made it clustered, hung up an index on a unique column.
Is it possible to put a trigger on this view?
The problem is that I can't put a trigger on a view...

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Artyom Karetnikov, 2017-02-27
@one__for__one

For the last five answers, I only keep saying: I don’t need a trigger here, I don’t need a trigger here. :(
You need to look at Update-Insert ... OUTPUT ... - and you will be happy.