Viewing 15 posts - 2,401 through 2,415 (of 3,347 total)
I got it correct.
I was surprised at first at the "SELECT @i+=1" syntax. I knew about the compount operators and have happily used "SET @i=1", but seeing never realised that...
March 28, 2011 at 4:45 am
rmechaber (3/27/2011)
To me, it's goofy that 'yyyy-mm-dd' is not a universally acceptable and unambiguous date format (only 'yyyymmdd' is), but that seems to be the case.
It is goofy, indeed. Especially...
March 28, 2011 at 4:06 am
A good question. It would have been a great question if the author had not forgotten to specify the version - Powershell is not supported in SQL Server 2005, so...
March 24, 2011 at 2:41 am
Good question!
I missed it - I thought about potential blockers for changing collation of existing columns; I didn't stop to consider that ALTER DATABASE COLLATION doesn't affect those, but only...
March 23, 2011 at 3:25 am
A nice question. Thanks!
My only gripe (yes, I have one - nopt a big one, though) is that the difference between 1 and '1' is easily lost. I almost chose...
March 22, 2011 at 7:12 am
stefan.hoffmann (3/21/2011)
I'd like to disagree. While the last example uses only @var = column the explanation above it clearly states:
"If a SELECT statement returns more than one row and...
March 21, 2011 at 1:22 pm
stefan.hoffmann (3/21/2011)
hi Hugo,http://msdn.microsoft.com/en-us/library/ms187953.aspx
states that the result is defined as the value of the last row and not undefined as Umachandar in the Connect ticket says, should be corrected then.
That page...
March 21, 2011 at 8:12 am
stefan.hoffmann (3/21/2011)
What do you mean with "incomplete data"?
I only found these articles:
http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/05/18/449.aspx
http://ryanfarley.com/blog/archive/2004/03/01/390.aspx
They only explain the obvious: When assigning a single value using the SELECT @var = column FROM table...
March 21, 2011 at 7:14 am
Such a shame that the author did not include the disclaimer that says that this method is not supported and not guaranteed to return correct results. I have lost the...
March 21, 2011 at 6:40 am
Good question; superb explanation!
I guess that if the author had included "all of the above" as a fifth answer option, the rate of incorrect answers would have been a lot...
March 21, 2011 at 6:36 am
bitbucket-25253 (3/18/2011)
March 18, 2011 at 1:06 pm
bitbucket-25253 (3/18/2011)
THANKS FOR CALLING ME STUPID. YOUR ARROGANCE OR SHOULD I SAY EGOTISM IS APPALLING.
Hmmm. Are you now implying that your use of a non-universal date format was...
March 18, 2011 at 9:24 am
paul.jones (3/18/2011)
March 18, 2011 at 8:16 am
mbova407 (3/18/2011)
Msg 8135, Level 16, State 0, Line 1Table level constraint does not specify column list, table '#Money'.
Sql seems to think the first answer is correct.
I think you added a...
March 18, 2011 at 8:10 am
When will people ever learn about date formats?
The correct answer ("depends on the locale settings") was not listed, so I had to throw a coin to choose between theory a...
March 18, 2011 at 8:08 am
Viewing 15 posts - 2,401 through 2,415 (of 3,347 total)