Suprised at the results
Correct answers: 34% (81)
Incorrect answers: 66% (155)
Total attempts: 236
Thought many more would be correct, since BOL clearly states
If the target table has an enabled INSTEAD OF trigger defined on it for an insert, update, or delete action performed by a MERGE statement, then it must have an enabled INSTEAD OF trigger for all of the actions specified in the MERGE statement.
At 9:04 AM Eastern Standard Time
[Center]Correct answers: 33% (104)
Incorrect answers: 67% (208)
Total attempts: 312 [/Center]
If everything seems to be going well, you have obviously overlooked something.
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]