Primary key and Identity in Sql Server Database

Question

0.00/5 (No votes)

See more:

Hello Sir/Medam,
i have a little problem while i make table in database.
My table like this.

CREATE TABLE [Customer]
(
CustomerId int Identity(1,1) PRIMARY KEY,
CustomerNumber int Not Null Identity(1,1) UNIQUE

)
iS that possible to gives identity in 2 column of table like this.

Give me reply.....

Posted 28-Jun-13 20:44pm

keyur_raval

Add a Solution

Comments

Shafeequl 29-Jun-13 3:06am

i think its not possible to have two same identity in same single table...
Actually What you need to do??

RedDk 29-Jun-13 14:14pm

I see a code block that looks syntactically ok. When F5ing that block, does the interface you're using send back an error? If the answer to this question is "no", then ... it IS indeed possible.

4 solutions

Solution 1

You can not set two primary keys in one table but you can use composite key in your table or you can use unique key for not allow duplicate data.
If this one not solve your problem explain your question in brief with code.

Posted 28-Jun-13 21:01pm

jaideepsinh

Solution 2

Well...yes...but it won't do what you think it will.

You can't have two separate identity fields on the same row - they do not work well together, and if they did, they would always be the same number, so it would be ridiculous to have them both anyway.

What are you trying to achieve, that you think this is a good solution?

Posted 28-Jun-13 21:06pm

OriginalGriff

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)

Adarsh chauhan · Accepted Answer · 2013-06-29T01:15:00

Hello,

first you can have only one identity column per table, second i didn't get why you need two identity columns in your table?? As even if you get success to have two identity columns, you will get same sequence as a combination of these two (for eg. (1,1),(2,2,)....) which is useless i guess.. so what would be the benefit of that??

see if composite key works well according to your requirements... or tell us more that what you want to achieve so that we would be able to help you out.

CREATE TABLE [Customer]
(
CustomerId int Identity(1,1) ,
CustomerNumber int Not Null ,
PRIMARY KEY (CustomerId, CustomerNumber)
 
)

**Nirav Prabtani** · Accepted Answer · 2013-06-29T01:24:00

Solution 4

You can Assign Primary key in this manner.

C#

CREATE TABLE Persons
(
P_Id int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
CONSTRAINT pk_PersonID PRIMARY KEY (P_Id,LastName)
)

Posted 29-Jun-13 1:24am

Nirav Prabtani