How do I get an unique ID per transaction which has multiple insertions

Question

0.00/5 (No votes)

See more:

I had two text boxes in frond end which is productname and No.of.batches...For example I selected a product 'X' and No.of batches as 10..It will get 10 rows and user will insert the data when user clicks submit it will reflect in database too...My requirement is generate an ID automatically PER transaction...I had to get an unique ID for the whole operation...what should i do to get that?

What I have tried:

C#

How do i get an unique ID per transaction which has multiple insertions

Posted 2-Dec-16 20:08pm

sai bharath

Updated 6-Dec-16 10:02am

OriginalGriff

Add a Solution

Comments

OriginalGriff 3-Dec-16 2:57am

This is not a good question - we cannot work out from that little what you are trying to do.
Remember that we can't see your screen, access your HDD, or read your mind.
Perhaps if your show us via sample data, and indicate exactly what ID or IDs you are trying to get, and where?
Use the "Improve question" widget to edit your question and provide better information.

Tomas Takac 3-Dec-16 8:17am

What kind of id? You can use NEWID function[^] to create a GUID.

jaket-cp 5-Dec-16 10:28am

you may want to look at IDENTITY (Property) (Transact-SQL)
https://msdn.microsoft.com/en-us/library/ms186775.aspx

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

dbrenth · Answer 1 · 2016-12-06T10:02:00

Solution 1

If you want to do it entirely in SqlServer SQL, you merely need to set up your table with a column of the type uniqueidentifier, make it not null, and define the default value as

newsequentialid()

Then each time you insert a row, it will determine the id for that row automatically.

Good Luck
Brent

Posted 6-Dec-16 10:02am

dbrenth

Updated 6-Dec-16 10:03am

v2