I'd not heard of a language called 'a' so wasn't sure what 'a and c' meant!

I guess that this answer wasn't checked before being released. I was torn between 'A' and 'B' as both work just fine but 'B' seemed the more correct answer as...

We have had this same question asked several times over the last couple of weeks. How about a question using 'DATALENGTH' instead?

People come to...

Yes you are wrong. There...

This is a good question, marred by poor sytax checking. I agree that the ',RECOVERY' is nonesense (again). I'm surprised that the editor let this one slip through

If you're really disappointed and upset by this then I think it's time you got yourself a life!

Thank you sswords and bkelley for your responses. You have confirmed what I believed to be true i.e. renaming the machines is the best solution.

Sorry for the late response -...

I disagree with the posted reply. I can find nothing - even in the link in the explanation - that says a table variable is instantiated in memory whereas a...

Thanks Antares. I never realised that there was so much confusion about NULL's. You have clearly highlighted a big problem area.

WHY CAN'T NULL = NULL?????????????

Because NULL in SQL 92 is taken to mean Unknown Value, not NO Value. If the value is unknown, how can you say that it equals anything?

That...

I agree with axeld1980.

The statements made about setting a value to null rather than just not setting it are incorrect. It makes absolutely no difference whether the value is assigned...

The "IF UPDATE" syntax will not help in this case as the value may not have changed but the column may have been included in the update statement.

For example, if...

I think something is missing from previous suggestions. In an update trigger, there are three tables available to you:

1) the table itself

2) the 'inserted' table and

3) the 'deleted' table.

The inserted...

A better explanation of the question would have been much appreciated. I.e. pointing out that this syntax does not actually exist in SQL server at all.

Also, why is the question...

Like I said - never rely on implicit conversions !

Nothing wrong with the date format used if it had been explicitly converted to a...