Viewing 15 posts - 3,436 through 3,450 (of 7,484 total)
Gary Varga (6/12/2013)
Evgeny (6/12/2013)
Can someone change the date of this question? It is July but should be June! Question from the future )))
My son would say "Chill your beans!!!"...
June 12, 2013 at 9:29 am
wolfkillj (6/11/2013)
L' Eomot Inversé (6/11/2013)
June 11, 2013 at 10:02 am
Nice question that shows one of the less obvious pitfalls arising from implicit conversion. Pity the explanation doesn't explain why it works as it does. Of course if...
June 11, 2013 at 9:16 am
I got it right, but I can imagine lots of people getting it wrong because only one of the two even classes is directly relevant to upgrading from a release...
June 10, 2013 at 10:22 am
mtillman-921105 (6/8/2013)
June 8, 2013 at 6:14 pm
Golfer22 (6/8/2013)
PreviousJobTitle is 0% dependent on the primary key in my example. Was that not clear?
No, it was clear that you were misusing the term "dependent" to exclude "transitively dependent",...
June 8, 2013 at 5:58 pm
There isn't enough information to say for sure what the best approach will be in your particular case, but there are some general approaches to designing relational schemas that lead...
June 8, 2013 at 5:26 pm
martin.whitton (6/7/2013)
palotaiarpad (6/7/2013)
Whitout running the code it is only a guess.
Not strictly true.
"Float" uses binary representations of numbers. Therefore, in this example:
0.115 translates to 0.000111010111000 in binary
0.075 translates to 0.000100110011001
0.04...
June 7, 2013 at 12:13 pm
nenad-zivkovic (6/7/2013)
From BOL http://msdn.microsoft.com/en-us/library/ms187912(SQL.100).aspx
Avoid using float or real columns in WHERE clause search conditions, especially the = and <> operators.
Should be "Avoid using float or real columns." Period. Exclamation mark....
June 7, 2013 at 6:05 am
michlimes (6/6/2013)
default collation is choosen at installation process - so imo it could be CS_AS.
You can override the installation defaults when doing the installation. Then you don't have a...
June 6, 2013 at 3:04 am
sknox (11/13/2012)
L' Eomot Inversé (11/12/2012)
sknox (11/10/2012)
June 6, 2013 at 2:47 am
Something seems to have gone crazy in QotD listing:-
Date Title Category
Jul 8, 2013 COALESCE (worth 2 points) Coalesce
Jun 4, 2013 TOP and ORDER...
June 4, 2013 at 9:04 am
GilaMonster (6/4/2013)
Brandie Tarvin (6/4/2013)
Please 'splain?
It's referring to the number base.
dec 25, 25 in decimal, ie base 10. 2x10+5
oct 31, 31 in octal, ie base 8. 3x8+1
They're the same number. In...
June 4, 2013 at 8:45 am
Viewing 15 posts - 3,436 through 3,450 (of 7,484 total)