Viewing 15 posts - 196 through 210 (of 455 total)
paul.knibbs (6/17/2013)
... and third, I *always* use AS to specify column aliases because I find the alternative causes confusion....
Agreed. I got this one right primarily because I've been bitten by...
June 17, 2013 at 7:14 am
There is a bug in your answer. You say:
This means that the first query returns all rows from MyTable, the second only the rows with NumericColumn equal to NULL....
June 12, 2013 at 10:38 am
Good question! I would clarify the answer a little bit, though:
... the result returns the data type of the expression with the highest data type precedence.
should probably be
......
June 3, 2013 at 11:14 am
L' Eomot Inversé (5/30/2013)
But maybe there will be complaints from some who think QotD should test only knowledge and not reasoning (except perhaps very trivial...
May 30, 2013 at 7:25 am
SQLRNNR (5/6/2013)
What, no controversy for this question?Thanks Vinay
Funny you should say that. I answered with a small degree of uncertainty, and read the discussion with greater trepidation, because I was...
May 7, 2013 at 10:04 am
Hugo Kornelis (3/21/2013)
DDL is language that describes data structures. Truncate table does not in any way change the schema of a table. It only removes all data from a table...
March 21, 2013 at 7:58 am
paul s-306273 (3/21/2013)
Two pints for this?Wow!
You got two pints? All I got was points!
I want my two pints!
March 21, 2013 at 7:44 am
Stuart Davies (3/20/2013)
Nice and clear question - thanks Ron
Yes, but he did nothing to account for those of us who read through the question, came to the correct conclusion, and...
March 20, 2013 at 11:32 am
I'm curious: What was the point of the cursor-like WHILE and incrementing the ID by 3? Just Obfuscation? Why didn't you just write the query as:
SELECT ID AS 'Select number',...
March 18, 2013 at 8:27 am
I wasn't sure what the confusion was here. All of the values in the example SELECT...INTO are constants. When you create a constant, the format you express it in tells...
March 13, 2013 at 8:23 am
Great article!
This is definitely one of those instances where the journey is more valuable than the destination (for me, at least).
The methodical testing of the issue and possible solutions...
March 13, 2013 at 7:54 am
Michael Riemer (2/13/2013)
+1 to the above points.Great question as far as idea and content goes, but needs clarification as to where you are in the world!!
Actually, no it doesn't.
The only...
February 13, 2013 at 10:37 am
sipas (2/6/2013)
sknox (2/6/2013)
For example, take
8 / 4 x 2
The correct way is left-to-right:
8 / 4 = 2...
February 6, 2013 at 8:41 am
sipas (2/6/2013)
B Brackets first
O Orders (i.e. Powers and Square Roots, etc.)
DM Division and Multiplication (left-to-right)
AS Addition and Subtraction (left-to-right)
It actually doesn't matter whether you do...
February 6, 2013 at 7:52 am
Viewing 15 posts - 196 through 210 (of 455 total)