August 29, 2011 at 12:47 pm
Tom.Thomson (8/26/2011)
I suppose some might go for the "error" answer if they think that "define" is a reserved word that would need to be quoted when used as a table name, but I can't think of any T-SQL syntax that uses "define" in a way that would require it to be a reserved word so I don't know why anyone would think that. But 22% so have have thought that (or derampt up some other imaginary error).If it weren't for the fact that 22% of answers so far are "error" I would be predicting a high 90s correct answer rate for this one.
It's a syntactical thing for me. OUTPUT I knew, I expected it to whine about the lack of the column list on t2 since only two inputs were inbound from t1.
Good question though. I learned something, even if it had nothing to do with the intended question.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
August 30, 2011 at 8:12 am
Is it only me that is struggling to understand how we get 3 columns from a 1 column table..?
Viewing 2 posts - 31 through 32 (of 32 total)
You must be logged in to reply to this topic. Login to reply