This is an SQL question, but I hope someone can help. I have a table that I need to add a new ID column that starts with any number and increments by 1. I can do this automatically in the Design if I am creating a new table, by setting this up in Identity Specification. But how do I write an SQL statement to add numbers in an existing table, in a new column, that are consecutive and unique that already has over 1000 records? After I have the new field filled with numbers, then I can go to the Column Properties and set up Identity Specification to add a new ID number to new records that is consecutive.
Nancy Graham Air Cargo Web Developer 502.329.3263 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4928 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
