Identity Columns

Question

Identity Columns

Mahmood.BilalB

Ten Centuries

Points: 1303
More actions
April 9, 2013 at 8:59 pm

#270946

Comments posted to this topic are about the item Identity Columns

Viewing 15 posts - 1 through 15 (of 20 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

good question

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Mahmood.BilalB Ten Centuries Points: 1303 More actions · Answer 2

Mahmood.BilalB

Ten Centuries

Points: 1303

April 9, 2013 at 10:25 pm

#1605085

Thanks for the comments 🙂

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 3

Easy question. keep it up 🙂

+1

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

Good easy one 🙂

+1

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

baabhu SSCertifiable Points: 6205 More actions · Answer 5

Mahmood.BilalB (4/9/2013)
Comments posted to this topic are about the item <A HREF="/questions/IDENTITY+Property/97999/">Identity Columns</A>

I didn't knew the answer for this question. But based on the elimination I eliminated A and B. Because option A is table created successfully and Option C is again table created successfully but some condition. It gives way eliminate both A and B. I feel writer should have given option d may be closer to B made this question more interesting.

-- Babu

SQLDub SSC Veteran Points: 229 More actions · Answer 6

I answered a QotD correctly and I didn't guess! I am pretty new to SQL development (~6months) but I could see straight away there was an issue with the two IDENTITY.

These questions are really helping me improve, keep up the good work.

mtassin SSC-Insane Points: 23099 More actions · Answer 7

Good question... teaches some of the basics.

--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link[/url]
For tips on how to post your problems[/url]

kapil_kk SSC-Insane Points: 21316 More actions · Answer 8

SQLDub (4/10/2013)
I answered a QotD correctly and I didn't guess! I am pretty new to SQL development (~6months) but I could see straight away there was an issue with the two IDENTITY.
These questions are really helping me improve, keep up the good work.

That's why SQL ServerCentral is there.. Everyday new things to learn... 🙂

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

manik_anu SSCrazy Points: 2377 More actions · Answer 9

SQLRNNR (4/9/2013)
good question

+1

Manik
You cannot get to the top by sitting on your bottom.

Dana Medley SSCertifiable Points: 6764 More actions · Answer 10

Good question. You almost got me because of the lack of caffeine in my system, but at the last moment I noticed the other identity field.

Everything is awesome!

TomThomson SSC Guru Points: 104773 More actions · Answer 11

Good clear question.

It's surprising that almost a quarter of people got it wrong. Maybe a lot of people don't use identity columns, so don't know the rules about them?

Tom

bev.kaufman SSC Enthusiast Points: 173 More actions · Answer 12

Again, I got the right answer for the wrong reason. The fact that the topic was IDENTITY should have been a tip-off. But I'd never encountered the References keyword before, and when I looked that up, I saw it was used to create a foreign key, meaning to another table. How could this work when it was referencing a table which at that point didn't even exist? But it does, as I found out after removing the second Identity field.

Miles Neale SSChampion Points: 13147 More actions · Answer 13

Miles Neale

SSChampion

Points: 13147

April 10, 2013 at 9:35 am

#1605297

Nice

+1

Not all gray hairs are Dinosaurs!

Ken SSCoach Points: 17191 More actions · Answer 14

I would have expected higher than 75% correct on this question. But then again, I use identity columns all the time. Good back to basics question. Thanks!