Viewing 15 posts - 2,401 through 2,415 (of 3,348 total)
venoym (3/28/2011)
Server Version:10.0, 64-bit
Database Compatibility: 80
the snippet in the question copied verbatim into SSMS and worked. The result was 255.
I would have thought database...
March 28, 2011 at 12:29 pm
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
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
Viewing 15 posts - 2,401 through 2,415 (of 3,348 total)