how to correct Azure SQL DB Trigger error

Question

I wrote an AFTER INSERT Trigger in my Azure SQL DB, which works just fine from within SSMS.

However, I am working with a JavaScript developer creating an application which writes to the Parent Table. The calling application needs to capture what was actually inserted. So, the Javascript statement is: Insert Into {my Table]... OUTPUT INSERTED.* Values (..... The T-SQL OUTPUT clause description specifically states "Triggers cannot be defined on the target."

Does anyone have suggestions for another way around this limitation? Do we have write a Procedure to query the Parent and Insert Into the Child?

Toby Speight · Accepted Answer · 2018-02-21 09:37:47Z

1

DML statements cannot have any enabled triggers if the statement contains an OUTPUT clause without any INTO clause.

There's an article about this on the Microsoft SQL Programmability & API Development Team Blog.

edited Feb 21, 2018 at 9:37

Toby Speight

32.3k58 gold badges83 silver badges118 bronze badges

answered Feb 21, 2018 at 3:43

Alberto Morillo

15.8k3 gold badges29 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to correct Azure SQL DB Trigger error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related