generate automatically number

Question

0.00/5 (No votes)

See more:

i m using VB.net 2008 and Sql db as backend
on this software i m trying to generate automatically number as unique number or ID
can you help me on doing this

Posted 16-Dec-13 20:52pm

tanugarg

Add a Solution

Comments

Mike Meinz 17-Dec-13 9:15am

Read IDENTITY (Property) (Transact-SQL)

Read Difference between @@IDENTITY, SCOPE_IDENTITY, IDENT_CURRENT

Read SCOPE_IDENTITY (Transact-SQL)

Read Retrieving Identity or Autonumber Values

2 solutions

Solution 2

If you want a unique number that's globally unique you can use the NEWID() function in SQL.

SQL

SELECT NEWID()

will give you a GUID that looks like C7E987A9-958C-4A4C-95EC-E2AAEA6E0C08

Posted 17-Dec-13 2:36am

petervanekeren

Comments

[no name] 17-Dec-13 8:47am

Why this answer has been downvoted? GUID is maybe overkill, but used widely in windows!

And if all COM objects can be based on GUID (because it is so unique.....) why not a DB key????

And by the way all who have a little bit an idea about balanced index trees, GUID is better in this view.

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)

OriginalGriff · Accepted Answer · 2013-12-16T21:00:00

Solution 1

Edit your DB in SSMS, and add an ID column to your table: Set it as "int", and scroll the Column Properties window down to "Identity Specification".
Click the [+] to expand the property, and double click "(Is Identity)" to change it from "No" to "Yes".
Save your table.

SQL server will now provide a new ID value every time you save a row and will ensure that it is unique.
Do note that you cannot rely on the current value as an indicator of what the next value will be: if you do try you will work OK for testing, but the whole thing will collapse in production when you have more than one user. Only ever try to use an ID value after the row has been inserted.

Posted 16-Dec-13 21:00pm

OriginalGriff

Comments

CPallini 17-Dec-13 3:29am

5.

[no name] 17-Dec-13 9:30am

Please do also pay attention to the solution of petervanekeren. His solution is NOT THAT BAD!

OriginalGriff 17-Dec-13 9:38am

Why are you shouting at me?
Do you think I down voted his solution?
Look at the points spread: 1 vote of 1, one vote of 5. for an average of 3 - which means that the upvote and downvote were done by people with a similar authority reputation.
My rep points mean that when I up or down vote something, it has a large impact: if it had been my down vote than it would have taken someone with a very similar authority to mine to balance it that closely, or several lower rep people.

Assuming the upvote was yours (as seems likely) you should be shouting at someone with a similar rep to your own...probably the OP in this case.

(This is why I rarely down-vote: I have too big an impact, and do too much damage to peoples reputation. And when I do, I say why - so that they know what not to do next time!)

[edit]Typos - OriginalGriff[/edit]

[no name] 17-Dec-13 11:46am

Sorry it was in no way against you. I placed the comment here that there is a chance that the comment is noticed.

OriginalGriff 17-Dec-13 12:08pm

It's OK. I'm surprisingly difficult to upset, even by accident! :laugh:

[no name] 17-Dec-13 15:11pm

Just move mouse cursor on the right side of the star series and click by accident ;)