Duplicate value in Identity column

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Ankur » Duplicate value in Identity column

29 posts, Page 1 of 3

1 2 3 »»»

Duplicate value in Identity column

Rate Topic

Display Mode

Topic Options

Author

Message

AppSup_dba

Posted Saturday, August 14, 2010 12:46 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:11 AM
Points: 125, Visits: 499

Comments posted to this topic are about the item Duplicate value in Identity column

Cheers,
Ankur

Post #969419

malleswarareddy_m

Posted Sunday, August 15, 2010 10:17 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:00 PM
Points: 1,850, Visits: 985

hi,

I know that we can add explicit values to an identity column using

Identity_Insert on. but i thought that identify column will not allow duplicate columns.good question.lost one point but learned one new point.

Malleswarareddy
I.T.Analyst
MCITP(70-451)

Post #969540

ziangij

Posted Sunday, August 15, 2010 11:06 PM

SSCommitted

Group: General Forum Members
Last Login: Friday, May 17, 2013 2:53 AM
Points: 1,529, Visits: 359

good one... duplicates can only be avoided by having a constraint in place...

Post #969545

Koen Verbeeck

Posted Monday, August 16, 2010 12:26 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:39 AM
Points: 9,376, Visits: 6,472

Nice question. Usually an Identity column is used as a primary key (and thus having a unique clustered index), which will prevent the insertion of duplicate values.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #969568

Christian Buettner-167247

Posted Monday, August 16, 2010 1:25 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 6:12 AM
Points: 2,526, Visits: 3,620

ziangij (8/15/2010)

good one... duplicates can only be avoided by having a constraint in place...

...or by having a unique index in place.

Best Regards,
Chris Büttner

Post #969580

AppSup_dba

Posted Monday, August 16, 2010 1:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 6:11 AM
Points: 125, Visits: 499

And i thought i only didnt knew it Smile

Cheers,
Ankur

Post #969587

Danny Ocean

Posted Monday, August 16, 2010 4:57 AM

Ten Centuries

Group: General Forum Members
Last Login: Today @ 1:11 AM
Points: 1,085, Visits: 1,162

Good Question...

Keep Learning - Keep Growing !!!
http://growwithsql.blogspot.in

Thanks
Vinay Kumar

Post #969680

pjdiller

Posted Monday, August 16, 2010 6:26 AM

SSC-Addicted

Group: General Forum Members
Last Login: Thursday, May 02, 2013 10:26 AM
Points: 404, Visits: 274

I have to admint I wouldn't have gotten this one right, except for a similar question a few months ago. I still don't understand why one would want to create an identity and then break the rules of the identity. Seems like trouble Smile

Post #969715

Daniel Bowlin

Posted Monday, August 16, 2010 6:43 AM

SSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 1:10 PM
Points: 2,673, Visits: 2,418

Identity insert can be very dangerous. For a long time I couldn't see a use for it. Then I needed it to get 2 tables in 2 different databases into sync after they had fallen out of sync for some unknown reason. It saved me a lot of effort.

Post #969725

SanDroid

Posted Monday, August 16, 2010 7:09 AM

Ten Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:01 AM
Points: 1,232, Visits: 1,046

Only one person can insert identity on a column at a time, so WE can not... Hehe

Post #969746

« Prev Topic | Next Topic »

29 posts, Page 1 of 3

1 2 3 »»»

Permissions