Hi,<BR><BR>I want to know how to generate 8 digit Autonumber from MS SQL Database. is it possible?<BR><BR>Thanks in advance..<BR><BR>Arun<BR><BR>
This is because I need to generate a 8 digit number for all the members in my database... The Members will keep on increasing and I need it to be automated... <BR><BR>Can it be done?
just use the normal autonumber and 'format' it so it looks like an 8-figure number.<BR><BR>or use an identity seed of 8 figures "11111111". or "10000000"
Thanks Atrax.. It works but curious to know is it possible to make it Alfa numeric
commonly asked question and the answer is generally this : don't bother.
An easy way to do that is to use a integer column with seed 16777216 and Hex it it ASP.<BR><BR>To auto-increase an alfanumeric column in the database is a lot more work, but probably possible with the use of triggers or stored procedures.