I work with a VB.net Excel Add-in that is used to upload data to an accounting Transactions table in a SQL database.
A batch ID and Transaction ID is generated in my VB.net code but I would prefer that it is done in the SQL database
itself. I have never coded inside a SQL database. Where would I begin if this is possible.