And of course anyone who doesn't like questions on relational theory doesn't have to answer them!

David, thanks for your detailed explanation!

Ok, so if DIVIDEBY is algebra, could someone explain the answer please, for those of us who are not mathematicians.

I'm not sure why we should have maths questions in what is...

As Habib says, it could be that your table definition in Access is not in line with SQL Server.  Pay special attention to the Primary Key, as I have seen...

I've just tried it on both SQL 7 and 2000 and it only generates an error on 2000. 

I'm not complaining, it's nice to have an easy one for once.

I agree, I get the same thing, but isn't that answer 6?  As well as the error I get a date.

I'd like to understand more why this happens, I assume...

To clear the transaction log without backing it up:

Backup log MyDatabase with truncate_only

You may find that the physical file is still large, so you can force it to be shrunk using

dbcc...

Or even to explicitly use SET DATEFORMAT MDY so there can be no confusion.

Yes, luckily 6 wasn't a choice, so I was able to guess that the answer should be 7.

Well said!  It gets a bit tiring hearing people moan about the QOD because they don't agree with the answers.   If you don't like the QOD, don't do the quiz.  Simple as...

No, it's nice to have an easy question for once!

Thanks Frank, this information is very useful!  I was trying to ascertain if the differences in the results we are calculating in our...

Thanks, but what I actually meant was does anyone know which STDEV formula SQL 2000 uses?

Thanks.  I assumed that SQL was clever enough to ignore any unused portion of the precision when doing the above sums.  As the integer portion of my numbers was small,...