ok181ko (8/8/2013) paul.knibbs (8/8/2013)
newid() = '00000000-0000-0000-0000-000000000000'
The question is not correct. Answer is 0 (zero).
The question asked which of the answers were possible outputs of the statement. It never stated that *all* of the possible outputs were listed as answers. Plus, is it even possible for NEWID() to return a value that's all zeroes?
And You can prove that this can not be?
I can prove that particular value to be irrelevant:
Of course, this does not mean that there isn't a value for newid that would provide a checksum of 0, only that the value you selected is not it.
Puto me cogitare, ergo puto me esse.
I think that I think, therefore I think that I am.