CODEWITHSUNDEEP
sql.netsql-server
Satish Kumar
Satish Kumar

Reputation: 213

Does an Sql server Insert request wait for the Insert Trigger to complete?

If I make a request from my application to insert a row and the table has an insert trigger., Does my application request wait for the trigger also to complete or will it just return me the value once the insert is completed??

Upvotes: 0

Views: 1124

Answers (1)

GandRalph
GandRalph

Reputation: 635

Agree with comments. If you manually run an insert statement on a table with an insert trigger that then updates another row, it will return rows affected for both your own row and the row the trigger updated.

(1 row(s) affected)

(1 row(s) affected)

Upvotes: 1

Related Questions