Hi,
- A client is going to request 1K rows of IDs from the server.
- I have to make sure we have 1K ID's with clientID = -1, if not, I have to insert 1K new ID's into the table.
- I then have to link those 1K ID's with the clientID
- return reserved 1K ID's to the client.
Is it as simple as wrapping all of this into a Transaction?