Post reply

insert into identity column

  • April 2, 2006 at 11:58 pm

    #630322

    See the insert into... delete from... suggestions on page 1 of this thread. They should work ust fine and won't require a complete replacement of the table.You can put those into a script, or a stored procedure. Since you have a unique index on a colum, it might be necessary to move the record that you want to change the identity valu of to a temp table, delete the record, then inser from the temp table. See my first post.

    My comment about the system tables was a warning that you shouldn't try and update the system tables (sysobjects, syscolumns) to remove the identity property from a column

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing post 16 (of 15 total)

You must be logged in to reply to this topic. Login to reply