Loading ...
Sorry, an error occurred while loading the content.

Re: [SQLQueriesNoCode] Co-worker forgot id field

Expand Messages
  • Mark E
    If it s SQL Server, adding an identity column should auto seed it as if it were always there.  I ve had to do this numerous times in the past with SQL2k and I
    Message 1 of 2 , Jan 24, 2012
    • 0 Attachment
      If it's SQL Server, adding an identity column should auto seed it as if it were always there.  I've had to do this numerous times in the past with SQL2k and I just tested it in 2k8 R2.

      Mark



      ________________________________
      From: Charles Carroll <911@...>
      To: SQLQueriesNoCode@yahoogroups.com
      Sent: Tuesday, January 24, 2012 4:24 PM
      Subject: [SQLQueriesNoCode] Co-worker forgot id field


       
      so when he adds the field all existing rows have a 0 value.

      How do I get the 1000s of existing rows to get numbered after the fact...

      http://brian.chipsofttech.com/blogs/brian/post/Reseed-SQL-Server-Identity-Column.aspx
      did not help



      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.