how to generate auto increment id number in sql server

Question

0.00/5 (No votes)

See more:

how to generate auto genarete id number in sql server,

I need a adding my From Auto increment ID number.My id number Format is
INV001.How to genarete a this kind of id Number.

I use this one .It only Numbers.i Need a ID number with character.

SQL

CREATE TABLE Persons
(
  ID int IDENTITY(1,1) PRIMARY KEY,
  PRIMARY KEY (ID)
)

Anyone can help me.Thank You

Posted 3-Oct-13 18:46pm

Hasitha Wijesooriya

Updated 3-Oct-13 18:48pm

codestar007

v3

Add a Solution

5 solutions

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)

codestar007 · Answer 1 · 2013-10-03T18:52:00

Solution 1

http://forums.asp.net/t/1920621.aspx[^]

auto-increment-of-alphanumeric-number-using-C-Sharp.aspx[^]

Posted 3-Oct-13 18:52pm

codestar007

Naresh1277 · Answer 2 · 2013-10-03T18:52:00

Solution 2

CREATE TABLE Persons
(
ID int NOT NULL AUTO_INCREMENT,
PRIMARY KEY (ID)
)

Posted 3-Oct-13 18:52pm

Naresh1277

Adrishya · Answer 3 · 2013-10-03T18:54:00

Try This

Right Click on table you want to add increment and goto design mode.
Select the primary key and see below
You can see + in Identity Specification make that yes and click on that +
and select the increment ie. 1,2,3 and select the identity seed 1,2,3 or whatever u like

identity seed means the point you want to start from and identity increment is the value that you like to increment by

for eg. if you select 2 as identity increment and 5 as identity seed then the output will be
5
7
9

for eg. if you select 1 as identity increment and 1 as identity seed then the output will be
1
2
3

Madhu Nair · Answer 4 · 2013-10-03T18:55:00

Solution 4

Using Sequence in SQL Server. I think that will definitely serve your purpose. Check this link for more information -

http://technet.microsoft.com/en-us/library/ff878091.aspx[^]

Posted 3-Oct-13 18:55pm

Madhu Nair

Rakesh Meel · Answer 5 · 2013-10-03T18:55:00

Solution 5

visit here..

Auto generated sequence number in SQL Server[^]

or

http://javarevisited.blogspot.in/2012/12/create-auto-incremented-identity-column-oracle-sequence-sql-server-mysql-sybase.html[^]