Viewing 15 posts - 496 through 510 (of 658 total)
Of course strictly speaking the result will be 90.3400 as the result will be of type money 🙂
April 18, 2011 at 2:12 am
Not sure which is worse - a mistake in the question, or the fact that a squillion people feel obliged to point it out despite there already being several pages...
April 12, 2011 at 9:10 am
bradphilp (4/10/2011)The answer is 6. How do these people actually consider themselves professional when they cant even answer questions they write?
How deliciously ironic!
April 12, 2011 at 9:07 am
sandippani (3/29/2011)
March 29, 2011 at 7:31 am
Tom.Thomson (3/26/2011)
March 28, 2011 at 6:28 am
bitbucket-25253 (3/24/2011)
In my opinion is it is so trivial that it can not be classified as a bug
Just because it's trivial doesn't mean it's not a bug - it's...
March 24, 2011 at 8:18 am
Asan Buhari (3/22/2011)
I wondered how SQL Server accepted an extra comma at the end of Create Table statement!
No-one seems to have addressed this yet?
Undocument feature, or bug?
March 23, 2011 at 3:19 am
Duncan Pryde (3/22/2011)
That's kind of the "moral" of the question. Never use a "bigger" decimal/numeric than you actually need.
The moral I've drawn is that maybe Floats aren't as bad as...
March 22, 2011 at 4:25 am
Duncan Pryde (3/19/2011)
March 21, 2011 at 3:02 am
bitbucket-25253 (3/18/2011)[hr
Yes I did
It worked!
Did you find any explanation of this behaviour?
March 18, 2011 at 8:49 am
I was about to put that the insert would fail (because for most of us outside the USA it will, I wrongly guessed that was the point of the question).
But...
March 18, 2011 at 4:02 am
The revised script works, but returns lots of duplicates, and also includes primary/unique key indexes (it doesn't matter if an index is 'used' if it's there to enforce integrity).
March 17, 2011 at 4:35 am
ziangij (3/16/2011)I really didn't know that by adding Begin, End (twice or more), we can return 2 recordsets.
You don't need multiple begin/end pairs to return 2 recordsets.
create proc test
as
begin
...
March 17, 2011 at 3:28 am
...and XML is wrong, but the explanation then states that XML is one of the valid types.
Perhaps this is anither of those questions which were changed by the writer but...
March 11, 2011 at 1:56 am
mohammed moinudheen (3/7/2011)
Thank you Ron. Seems to be easy, most of them got it right 🙂
Only 80% at the moment.
I'm intrigued about the 2% who answered "2" 😉
March 8, 2011 at 2:56 am
Viewing 15 posts - 496 through 510 (of 658 total)