Solution:
Like if your table name is InvoiceTbl
than do this
1. Make InvioceNo column identical like identity(1, 1)
2. Run this query to get next number:
SELECT Max(InvoiceNo) FROM InvoiceTbl
This will return you max invoice number.
2. Add One (+1) to the returned number.
3. ave the new record