Viewing 15 posts - 2,041 through 2,055 (of 3,347 total)
(Bob Brown) (8/27/2012)
Hugo Kornelis (8/27/2012)
After reading this, I tested it for myself on my SQL 2012. I ensured no table named table1 or table2 exists, then executed this...
August 27, 2012 at 4:55 am
sam.dahl (8/26/2012)
This may well be...
August 27, 2012 at 3:34 am
mtassin (8/23/2012)
So what purpose did leaving out the table create statements or saying that we have to assume that they exist in the text prior to the code serve?
I don't...
August 23, 2012 at 10:04 am
mtassin (8/23/2012)
*sigh* I guess we'll just disagree here
Hmmm, I'd rather say that you are agreeing vehemently!
sknox writes: >>You happened to get it right because you didn't read that error message...
August 23, 2012 at 9:36 am
Steve Jones - SSC Editor (8/23/2012)
If you thought that you could do an insert into @x without defining @x, you would learn something...
August 23, 2012 at 8:55 am
A good question. I'll admit that I am surprised at the high number of incorrect answers; I would have expected 70 to 80 percent to get this right.
I'm not surprised...
August 21, 2012 at 4:06 am
sknox (8/20/2012)
Interesting. One could argue that this is a bug in SQL server, since cast('a' as int) logically cannot exist...
On one hand, I tend to agree with you. On the...
August 20, 2012 at 10:26 am
EL Jerry (8/20/2012)
August 20, 2012 at 8:51 am
I appreciate the amount of research that went into this question and I think it has a good educational value, but I don't think a QotD is the right form...
August 17, 2012 at 3:23 am
sestell1 (8/16/2012)
A good question. This is a drawback to using table variables for temporary storage that you need to remember to work around.
Actually, this is not a drawback and...
August 16, 2012 at 6:53 am
honza.mf (8/16/2012)
Hugo Kornelis (8/16/2012)
honza.mf (8/15/2012)
Lokesh Vij (8/14/2012)
rVadim (8/14/2012)
I think any comparison against NULL will yield Unknown, which is not True, and therefore records won't be returned.
+1
Yes that's correct!
+1
And even...
August 16, 2012 at 4:46 am
honza.mf (8/15/2012)
Lokesh Vij (8/14/2012)
rVadim (8/14/2012)
I think any comparison against NULL will yield Unknown, which is not True, and therefore records won't be returned.
+1
Yes that's correct!
+1
And even worse the answer...
August 16, 2012 at 2:38 am
buntyteg (8/14/2012)
means to say... in bit datatype how we can store 25 (2 digit) value
No. Any value other than 0 is converted to 1. So 1 is stored as given,...
August 14, 2012 at 12:40 pm
WayneS (8/14/2012)
August 14, 2012 at 7:48 am
L' Eomot Inversé (8/11/2012)and (even worse) more than a third people think it makes sense to evaluate constraints before executing instead of triggers.
Just for the record, even though it may...
August 11, 2012 at 3:35 pm
Viewing 15 posts - 2,041 through 2,055 (of 3,347 total)