Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: MitchMitch
- Order by date
-
Add a column with 2 characters and a 7 digit auto incrementing number
Also, I don't need tohe column to continue to autoincrement. I will do this in my code. I just said autoincrement to explain thatI don't want to have to increment it manually on initial input.- MitchMitch
- Post #2
- Forum: Sybase: Adaptive (SQL) Server
-
Add a column with 2 characters and a 7 digit auto incrementing number
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...- MitchMitch
- Thread
- Replies: 1
- Forum: Sybase: Adaptive (SQL) Server
