What is the reason for this restriction for Output clause?
If the OUTPUT clause is specified without also specifying the INTO keyword, the target of the DML operation cannot have any enabled trigger defined on it for the given DML action. For example, if the OUTPUT clause is defined in an UPDATE statement, the target
table cannot have any enabled UPDATE triggers.
View Complete Post