MitchMitch
Programmer
I have a table with about 2 million records that I need to add a new key to. The key needs to be two letters (ML) and then a 7 digit number, starting with 1 and it auto increments. (ML0000001 for example)
Does anyone have suggestions on the easiest way to do this? It appears that Sybase doesn't have sequence's like Oracle, where I could do this easily.
Thanks!
Mitch
Does anyone have suggestions on the easiest way to do this? It appears that Sybase doesn't have sequence's like Oracle, where I could do this easily.
Thanks!
Mitch