Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  updating identity columns

Author  Topic  hmusa Starting Member 36 Posts Posted - 2001-03-30 : 09:14:47 i am doing an insert from one table to another, the destination table has an identity column is there a way i can set the identity column to add 1 for each isert