What will be Identity value

Question

Post reply

What will be Identity value

Mitesh Oswal

SSCrazy

Points: 2798
More actions
March 24, 2014 at 8:23 pm

#396475

Comments posted to this topic are about the item What will be Identity value
Regards,
Mitesh OSwal
+918698619998
March 25, 2014 at 4:37 am

This was removed by the editor as SPAM

Viewing 14 posts - 1 through 13 (of 13 total)

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

Ron McCullough SSC Guru Points: 63877 More actions · Answer 1

Rather simple question, but a Nice question -

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Hany Helmy SSChampion Points: 13921 More actions · Answer 2

Basic but mostly forgotten, so thank u very much 4 the question.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

free_mascot One Orange Chip Points: 27169 More actions · Answer 3

Good and easy one!

Thanks!

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."

PurpleLady SSCertifiable Points: 7819 More actions · Answer 4

PurpleLady

SSCertifiable

Points: 7819

March 25, 2014 at 5:17 am

#1699797

Good one - had forgotten about the column list:)

Ed Wagner SSC Guru Points: 287026 More actions · Answer 5

Good basic question, but we can't forget the basics.

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Revenant SSC-Forever Points: 42467 More actions · Answer 6

Very simple, very straightforward - thanks, Mitesh!

SQL Severe DBA Hall of Fame Points: 3579 More actions · Answer 7

SQL Severe DBA

Hall of Fame

Points: 3579

March 25, 2014 at 10:09 am

#1699959

Thanks for question Mitesh , hope you doing good.

Koen Verbeeck SSC Guru Points: 259115 More actions · Answer 8

Nice question, thanks.

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

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 9

PurpleLady (3/25/2014)
Good one - had forgotten about the column list:)

+1

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

honza.mf SSCertifiable Points: 5519 More actions · Answer 10

I hate inserts without colmn list. They make only troubles.

Primo Dang SSCrazy Points: 2643 More actions · Answer 11

Nice question, thanks!

I got lucky with my answer, I thought the error would be trying to insert a duplicate value in an identity column. In retrospect, I see there's no reason to assume an "implicit" unique constraint on identity columns.

Umer Akram SSC-Insane Points: 22209 More actions · Answer 12

Umer Akram

SSC-Insane

Points: 22209

March 28, 2014 at 12:49 am

#1700986

Nice question, refreshed my memories 😛