BUG: SELECT INTO from a View May Cause Extra Error Messages

  - Microsoft SQL Server version 4.2a for OS/2
  - Microsoft SQL Server version 4.2

SYMPTOMS

A SELECT from a view with an INTO clause may cause an error indicating a type mismatch in the WHERE clause when one does not exist. This happens if the WHERE clause contains two consecutive comparisons of a given type followed by a third involving an implicit conversion.

Possible messages would be:

   Msg 206, Level 16
   State 2 Operand type clash: int is incompatible with smalldatetime

   Msg 257, Level 16
   State 1 Implicit conversion from datatype 'int' to 'char' is not
   allowed. Use the CONVERT function to run this query.

WORKAROUND

Create the target table and use an INSERT with a SELECT instead of a SELECT INTO.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2a for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.