The car companies want to get in the data collection business as much as Google and Facebook already are. This is not good news for consumers, especially, car enthusiasts, as...

I do not know which sp3 you are running but it worked just fine on mine

SELECT Serverproperty('Edition') as Edition,

Serverproperty('EngineEdition') as Engine,

...

The following works without errors in SQL 2005. The table is created, the values inserted and the results selected.

Create Table Test(col varchar(10))

GO

Insert into Test

Select 1

union Select 2

union Select 3

union Select...

It is the explanation that is wrong. The values are inserted into the table, just fine.

The error occurs when 'A' is tested Between 1 and 6 in the WHERE clause.

This...