Identity Values

Question

Post reply

Identity Values

Orlando Colamatteo

SSC Guru

Points: 182293
More actions
January 22, 2013 at 11:06 pm

#273220

Comments posted to this topic are about the item Identity Values
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
January 23, 2013 at 12:30 am

This was removed by the editor as SPAM

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

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

kalyani.k478 Default port Points: 1400 More actions · Answer 1

kalyani.k478

Default port

Points: 1400

January 22, 2013 at 11:28 pm

#1579905

+1 thanks

manik_anu SSCrazy Points: 2397 More actions · Answer 2

nice question.....

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

Dineshbabu Hall of Fame Points: 3220 More actions · Answer 3

Nice question.

From the explaination I understood even duplicate values can be generated using DBCC CHECKIDENT.

--
Dineshbabu
Desire to learn new things..

Koen Verbeeck SSC Guru Points: 259155 More actions · Answer 4

Great question thanks. I vaguely remember seeing a similar QotD once, but it's quite some time ago.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sqlnaive SSCoach Points: 17437 More actions · Answer 5

It was a basic but very good question. I was in little confusion over the second value but when concentrated, got it right and earned 1 point.

ajit.ghule Mr or Mrs. 500 Points: 598 More actions · Answer 6

ajit.ghule

Mr or Mrs. 500

Points: 598

January 23, 2013 at 1:12 am

#1579929

Nice Question.:-)

Lokesh Vij SSChampion Points: 10836 More actions · Answer 7

Good one. Thanks!

~ Lokesh Vij

Guidelines for quicker answers on T-SQL question[/url]
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com[/url]

Follow me @Twitter

Gazareth One Orange Chip Points: 27737 More actions · Answer 8

Gazareth

One Orange Chip

Points: 27737

January 23, 2013 at 2:45 am

#1579964

Good question, this behaviour could be a gotcha.

(Bob Brown) SSCrazy Points: 2705 More actions · Answer 9

(Bob Brown)

SSCrazy

Points: 2705

January 23, 2013 at 4:05 am

#1579989

Thanks the great midweek question.

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 10

Simply the best. thank you for posting..

(even though got the wrong answer, and really not sure why i considered the check-box as radio-buttons and then clicked only 101... and then #facepalm)

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 11

Thanks for the question. Always good to highlight things that have surprising behaviors.

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 12

Good question. In hurry i picked wrong..

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

Bob JH Cullen SSCrazy Points: 2082 More actions · Answer 13

OK. I got it wrong because I tried to apply what I thought was sensible logic to the choice of the second value. Can anyone explain why SQL uses such bizarrely inconsistent behaviour?

Identity Values

Cookies on SQLServerCentral