robrodp
asked on
MS Sql Convert int column to identity conserving data
I have a field with integers, they are not repeated and go from 1 to 1000, I need it to set it as an identity column (1,1) preserving the data it has since it is the key for a relation with another table.
This table was imported from a system that incremented this field by 1 manually.
This table was imported from a system that incremented this field by 1 manually.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.