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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.