Recently I needed to add an Identity column to a table which is already populated. Of course, adding a new column to a table with identity property can be done easily. But the problem is to generate values for the existing records in a custom order, as the values are getting generated automatically...
