I was trying to answer this question stating from clause is optional..But i am stuck with an Operator in plan..below is screenshot of execution plan ..
As you can see there is BMK operator in query plan ,but no indication showing how it is calculated..
steps i have tried so far:
I started searching with BMK1000 ,but it shows a bunch of questions with the same operator.finally i found one thread which says "The BMK that you're referencing is the storage location within the heap that gets kept with the nonclustered index instead of the cluster key."..But not sure how this is related to me,since i don't have any indexes..
what is the BMK operator and how it is calculated.Any Pointers also will be helpfull
Here is SQLFiddle to Repro the issue