Viewing 15 posts - 1 through 15 (of 52 total)
With 3 correct choices out of 4, I'd phrase it "Which statement would NOT run correctly" and dispense with multiple choices. /nitpick
An easy question. I always use AS when I...
June 20, 2013 at 5:56 pm
Koen Verbeeck (3/22/2013)
So a part of the correct answer is "all styles below 100" are non-deterministic, but another answer is "not 20,21", because they are deterministic...
Koen Verbeeck (3/22/2013)
Well, the question was which...
March 22, 2013 at 5:00 pm
Well, if ALL you want is the two counts, why not do this?
Count1 = (select COUNT(*) from #Table1),
Count2 = (select COUNT(*) from #Table2)
February 5, 2013 at 6:08 pm
Well, the good news is, I got NULLs down pat. The less good news is, I didn't even stop to think about type precedence.
Conclusion - time for more coffee.
February 5, 2013 at 5:54 pm
Nice easy question, with a bonus discussion about one-row tables. 🙂
On the second thought, the table in the question allows 0 or 1 rows, while Hugo's example ensures that the...
January 29, 2013 at 10:53 am
Nice and easy afternoon question, here. 🙂
November 15, 2012 at 5:05 pm
Right, poster #627 to complain about the wording. With the little twist that I stared at it, thought I spotted the gotcha and said, "Aha! The batch returns an error,...
October 5, 2012 at 5:11 pm
The benefit of replying a few days later and fully caffeinated. 😀
Even so, I almost missed the INSERT ... SELECT part. :hehe:
Fun question, and yes, a helpful technique for populating...
September 12, 2012 at 5:38 pm
Hugo Kornelis (9/6/2012)
I think that is because CROSS APPLY is more like not use explicit joins, as in SQL ANSI '92.
I'd put it differently. The only difference between...
September 6, 2012 at 3:00 pm
It drives me nuts to see column definitions without a NULL or NOT NULL constraint.
September 4, 2012 at 5:05 pm
Well, sheesh, way to make it simple! I was having such fun with my pivots! 😀
August 24, 2012 at 3:16 pm
Under what conditions is it acceptable to attempt an insert but not care whether it happens?
I was wondering the same thing.
Specifies the error response when an insert operation...
June 11, 2012 at 6:02 pm
The question was quick and easy. It's the last line in the explanation, about alias column names in WHERE that made me go, "Oh!" One of those things I knew,...
May 7, 2012 at 5:31 pm
I spotted the gotcha, and got it right. I do think it would have been a more educational question if it focused just on the date and time element, without...
September 27, 2011 at 12:02 pm
Carlo - absolutely that is confusing. When I intend to alias the column, I prefer to use [ColumnName] = col1 syntax, which aligns all my column names nicely.
September 14, 2011 at 12:36 pm