Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fugazi
Starting Member
6 Posts |
 Posted - 2010-01-12 : 11:03:53
|
| Hello! I would like to create sequential lot number starting with E0001 to E9999 in my table (SQL 2000). Is there a simple query to create this? tablename: rstk_productlotcolumn: lotnumberbest regards, Fugazi |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-12 : 12:03:11
|
| http://www.sqlteam.com/article/custom-auto-generated-sequences-with-sql-server |
 |
|
|
fugazi
Starting Member
6 Posts |
Posted - 2010-01-12 : 15:11:53
|
| excellent! thanks a lot for your answer!! Fugazi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-01-13 : 01:18:04
|
welcome  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Creating Sequential entry