Viewing 15 posts - 2,356 through 2,370 (of 3,348 total)
Thanks, all, for the kind words!
SQL Kiwi (11/9/2011)
"SQL Server will use the same amount of storage for a column whether...
November 9, 2011 at 2:05 am
But the reason of the bug is because the query is done on the master or because there is "a non-explicit type conversion on the right hand side" (but...
November 9, 2011 at 1:58 am
bopeavy (11/8/2011)
Hugo Kornelis (11/8/2011)
Not a very good question, but I can forgive the author for that. Reading the reactions so far, there are various versions of...
November 8, 2011 at 9:39 am
Not a very good question, but I can forgive the author for that. Reading the reactions so far, there are various versions of SQL Server where this will blow up....
November 8, 2011 at 4:42 am
Robert.Hoffman (11/3/2011)
Wouldn't the example given also error out if for some reason a Customer had more than one CustomerRefNo returned?
No. In that case, it would (more or less random (*))...
November 3, 2011 at 9:46 am
A nice question about a little known feature - but you have to overllook the errors.
I'll admit that I did not see the declare + set statement, as I was...
November 3, 2011 at 3:07 am
michael.kaufmann (11/2/2011)
Hm, do you have an explanation why the following code will return the exact same result? :crazy:
My guess would be that your server has a default collation of Latin1_General_CI_AS....
November 2, 2011 at 6:08 am
SQL Kiwi (11/1/2011)
Hugo Kornelis (11/1/2011)
Your production code will likely be more careful with these issues.
Can I interpret this as "Your production code will likely completely avoid the use...
November 1, 2011 at 3:20 am
Great question, Paul!!
Your production code will likely be more careful with these issues.
Can I interpret this as "Your production code will likely completely avoid the use of SQLVariant"?
(Okay, there may...
November 1, 2011 at 1:47 am
Thomas Abraham (10/31/2011)
October 31, 2011 at 5:43 am
gary.rumble (10/28/2011)
Hugo Kornelis (10/27/2011)
I had the correct answer,but only thanks to the fact that I attended SQL Saturday in Portland a few weeks back (just before the PASS...
October 28, 2011 at 2:52 pm
rdavis-573289 (10/28/2011)
Would it not be a good idea to remove a question which is wrong from the list of questions?
Steve normally corrects questions that are obviously wrong, but he is...
October 28, 2011 at 2:40 am
Good question, Paul!
I had the correct answer,but only thanks to the fact that I attended SQL Saturday in Portland a few weeks back (just before the PASS Summit). I don't...
October 27, 2011 at 4:59 am
jshahan (10/24/2011)
Fine. Show me code that will update Col1 in a table that where that column doesn't exist and I'll agree with you.
Below is a cut and paste of...
October 24, 2011 at 4:22 pm
jshahan (10/24/2011)
Impossible is absolutely the correct answer. Col1 does not exist and cannot be updated.
The question was how to update column1, not col1. So impossible is absolutely NOT the...
October 24, 2011 at 4:13 pm
Viewing 15 posts - 2,356 through 2,370 (of 3,348 total)