Member Avatar for soeppp

hi daniweb...
i need some help for my projects...maybe u all can help me....

i want to make a autonumber field in sqlserver and will be reset to 1 every 1st day in a new month....it will be use for document numbering..because i want to make the doc format is like 0910.0001 where 0910 is year and month and 0001 is and autonumber...and it will be reset to 0911.0001 at the new month....

thx for the attention....

  • 2 Contributors
  • 1 Reply
  • 95 Views
  • 20 Hours Discussion Span
  • Latest Post Latest Post by kvprajapati
Member Avatar for kvprajapati

You need to know the MS-SQL server string functions. However it can be done through the statement of programming language. Please show us your code.

Edited by kvprajapati because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.