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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-18 : 08:22:44
|
| Montesh writes "sir i'm currenlty preparing an OLTP system in SQL Server 2000, VB6It is such that it shall be multi user , The system is an Order/Invoicing systemNow i have to generate unique auto numbers which shall be reset to one every year I have decided to have it alpha numeric i.e. A00001 for the year 2000/2001 financial years first voucher number in the orderand similarly in the invoicingIt is so required that during saving of the Master record,i shall have a (Select max(voucher_no) +1 ) saved as the voucher number for the next record . I'm confused as how to implement it Please guide me for this . suggest me some good book which has implementation for such a kind of system." |
|
|
|
|
|
SQL Server application Development with VB6