March 5, 2013 at 3:24 am
jholman (3/4/2013)
Agreed - good question. However the stmt in the explanation is invalid. The alias, 'WTH' was not used in the FROM clause so the SELECT wth.* has no alias to match to. It happens.
Huh, that's strange! I am 99% certain that when I answered the question (the day it was out), the code in the explanation read:
SELECT WTH.* FROM #TEST AS WTH (NOLOCK)
March 5, 2013 at 7:02 am
The original post for the question had SELECT * FROM #TEST WTH(NOLOCK)
which was all that was needed to answer the question, in the "blurb" that provided the answer, I did forget to add in the alias 😀
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 13, 2013 at 12:05 pm
Dineshbabu (2/21/2013)
Nice and easy one. Initially I overlooked the word WTH and answered the question. After seeing the explaination only i realised it was mispelled and it will act as alias name.Thanks for your brief explaination Chris Büttner ...
+1
March 28, 2013 at 4:25 am
didn't even see that WITH was mispelled ! lol
got 1 point abusively
June 25, 2015 at 12:18 am
I thought it was a joke.
But after reading the explanation I noticed the WTH instead of WITH
Oeps , just lucky that I was right
Viewing 5 posts - 31 through 34 (of 34 total)
You must be logged in to reply to this topic. Login to reply