BUG: Inconsistent Timestamp Behavior in Stored Procedure (88931)
The information in this article applies to:
- Microsoft SQL Server 4.2x
This article was previously published under Q88931 SYMPTOMS
When you copy a table that has a timestamp column into
another table by executing the following queries in a stored
procedure, you may get error 273 ("the user cannot insert a
non-null value into a timestamp column") the second time you
run the procedure.
SELECT * INTO table1
FROM table2
WHERE 1=2
INSERT INTO table2
SELECT * FROM table1
The stored procedure works well the first time. But if you drop
table2 and rerun the stored procedure, SQL Server gives you
error 273 ("the user cannot insert a non-null value into a
timestamp column").
Then if you drop table2 again and rerun the stored procedure,
it works correctly.
It always works correctly when SQL Server does not copy the
timestamp columns from table1 but instead creates new timestamp
columns.
WORKAROUND
In the INSERT statement, list all table1's columns except the
timestamp column.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 4.2, 4.21, and 4.21a. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.
Modification Type: | Minor | Last Reviewed: | 2/14/2005 |
---|
Keywords: | kbProgramming KB88931 |
---|
|