4778Re: [SQLQueriesNoCode] Co-worker forgot id field
- Jan 24, 2012If 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.
From: Charles Carroll <911@...>
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...
did not help
[Non-text portions of this message have been removed]
- << Previous post in topic