Environment: C#.Net, Sql Server
I need to create an invoice number in an application which is auto generated for each account.
Below are the 2 options I know. Please advise what would be the best approach to implement this functionality.
1). Identity column
2). Create a table in SQL Server that has just 1 column and 1 row. and insert number 1 in there. Now everytime, I want to create an invoice number I can read the value from this counter table and add 1.