Identity Field Issue - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Identity Field Issue

Author

Topic

kathyc2003
Starting Member

15 Posts

Posted - 2007-06-22 : 09:19:34

Hello,

I have a field in my table called "MyNewCounter",
where the data type is int.

Unfortunately I set the identity field to "No" instead
of "Yes" on this field.

Since this time a few thousand records were imported
in and this field is now set to a value of null for all records.

When I tried to change the identity to "Yes" and save
the table, I get an error indicating that the field can not
contain a null value.

If I populated this field with numeric values, would this
correct my issue? and if so, what SQL command would
I use to set the field value starting at 1 to increment
for each existing record?

nr
SQLTeam MVY

12543 Posts

Posted - 2007-06-22 : 10:11:18

drop the column and add a new identity column which will be automatically populated.
The old dropped column will probably still take up space but that shouldn't matter.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources