Viewing 15 posts - 526 through 540 (of 656 total)
I didn't even notice it said SQl2000/2005 - somehow I always assume that questions will be targetted at the latest release.
I must admit that I ran the script before answering...
December 23, 2010 at 3:18 am
I get a pile of errors when I run it - Cannot insert the value NULL into column 'Seq'.
I eventually worked out that this is because I have ANSI_NULL_DFLT_ON set...
December 22, 2010 at 3:59 am
Once again we learn that you should never rely on default datatype precision, but specify it yourself!
December 13, 2010 at 10:10 am
Nils Gustav Stråbø (12/9/2010)
December 9, 2010 at 8:31 am
The first and third answers are definitely correct (the first being a subset of the third), so I went for 'all of the above'. A good question, spoiled slightly by...
December 1, 2010 at 3:09 am
I got it wrong, as the last time I tried any DDL within a transaction was 15 years ago in my Oracle days, when such changes could not be rolled...
November 24, 2010 at 8:44 am
Excellent question - which I got right due to having been buitten by exactly this problem in the past, and it took ages to track down the cause
November 22, 2010 at 5:40 am
Even ignoring the date format problem, what is this question supposed to teach us? Why would anyone want to convert a date to a float?
November 5, 2010 at 3:32 am
tilew-948340 (11/4/2010)
My engish beeing what it is, I did also not get the differance between the first two
Don't worry about it, I've lived in England for all 47 years...
November 5, 2010 at 3:25 am
I knew what the answer was, and thought that "The maximum Tax Rates across all State/Province IDs" described it well. I supopose I should have read more closely and realised...
November 4, 2010 at 3:19 am
I hope one thing that everybody has learned from these questions is that you should never rely on default precision for anything - you will inevitably get it wrong sooner...
November 2, 2010 at 7:06 am
Christian Buettner-167247 (11/2/2010)
Hm, am I the only one who thinks the given answer is false?
Almost certainly
November 2, 2010 at 3:36 am
Knew the answer but had a brain fart and clicked the wrong option, oops!
UMG Developer is right about the explanation.
November 2, 2010 at 3:35 am
Viewing 15 posts - 526 through 540 (of 656 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy