I knew there was a discussion on similar question recently, still got the answer wrong 🙂

Whilst, I was trying to look at the queries executed in estimated execution plan, my eye caught something. What ever operation is performed after "SET QUOTED_IDENTIFIER ON;", it is treated as a single query along with QUOTED_IDENTIFIER.

Would really appreciate if someone can pitch-in and explain.

Thanks!