Koen Verbeeck (11/28/2012)
The only correct answer is 0.There are 8 statements in the estimated execution plan, but no queries.
From BOL:
A query is a request for data that is stored in SQL Server.
There isn't a single statement in the batch that does a request for data, hence no queries.
+1
Toreador (11/28/2012)
I didn't understand the question at all, so guessed. Having read the explanation I was none the wiser.So I tried it, and the execution plan was empty.
confused.com
+1
_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]