Slawomir Swietoniowski (5/12/2013)
This question is stated wrong, cont(...) does not have any alias for the name, so, while you will try to execute this code, you will get:Msg 1038, Level 15, State 5, Line 1
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
My guess is that is why only ~50% percent people guessed correctly, the rest might assume that lack of an alias is the "tricky" part of this question...
+1 here too. As far as I know you should be able to copy the query and run it.
But something I found out, which was more interesting, is that when you use a table from a linked server, that it won't create a field with the identity property, even not when the linked server is that instance itself (so a four part name to the current server).