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.
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.