Auto numbering format

[makumbi]

Hi members iam using sql server 2000

i have a table named catecodes
with the following colums
bookcodes
and the format of coding is
0001-0001
0001-0002
0001-0003

or
0002-0001
0002-0002

etc

is there a code in sqlserver 2000 i can use to automatically generate these numbers in this format without typing them manually
where by the user just enter 6 and then the code increments these number up to that number in put.

 

[bborissov]

No,
SQL Server can't handle such increment internally.
You must do it by yourself.
You could write a function which could handle it and set it as a default value to this field.

Borislav Borissov
VFP9 SP2, SQL Server 2000,2005 & 2008.

 

[simian336]

It the user is entering it that is normally handled by a front-end program. What are you using to allow the user to enter data?

Simi

 

[makumbi]

hi simian336 iam using access project(ADP) as my front end