copying a record with a timestamp field
Posted on 2013-11-25
I wish to insert records from one table into another in the same database.
Both tables have the same structure.
I am using
insert into Table2
select * from Table1
but I receive the error message "Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column."
I then tried to use the column list method
INSERT INTO [dbo].[Table2]
but this resulted in a list of error messages such as:
"The multi-part identifier "dbo.Table2.Field1" could not be bound."
Can anyone help me update this table?