Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/170318

From BetaArchive Wiki
Knowledge Base


Article ID: 170318

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q170318

BUG #: 15818 (NT: 6.50)

SYMPTOMS

When attempting to insert the value 'NULL' into a timestamp column with ANSI_NULLS enabled, error 273 is returned:

The user can't INSERT a non-null value into a TIMESTAMP column. Use INSERT with a column list or with a default of NULL for the TIMESTAMP column.

WORKAROUND

To work around this problem, do either of the following:

  • Disable ANSI_NULLS before inserting NULL into a timestamp column, as in the following example:

          create table tblNull ( iId int, timestamp )
          go
    
          set ansi_nulls off
          go
    
          insert tblNull values (1, NULL)
          go
    
                            

    -or-

  • Use a column list on the INSERT statement and omit the timestamp, as in the following example:

          insert tblNull (iId) values (1)
          go
    
                            


STATUS

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

MORE INFORMATION

You may encounter this problem when you attempt to use the Microsoft FoxPro Upsizing Wizard. The current version of the Upsizing Wizard does not allow you to disable the 'Add Timestamp' feature. For a technique to work around this problem, see the following article in the Microsoft Knowledge Base:

139757 : FIX: Upsize Wizard Falsely Creates Timestamp Field on SQL 6.0



Additional query words: 6.50.201

Keywords: kbbug kbinterop kbusage KB170318