Go to the page referenced in the explanation of the question; scroll all the...

Glenn Dorling (4/20/2010)

---

Sorry Hugo, but I have to add my voice to the nay-sayers.

For the first part of the question your answer is based on the fact that by default...

Good, clean question, Ron. Nice work!

The question explicitly states:...

I see a lot of new comments have been posted while I was away. Thanks all for the feedback! I think that there's too many of them to address every...

Tom Brown (4/20/2010)

---

A Good question. I learned something from this.

I've used IDENTITY for ages, assuming its both duplicate-proof and automatically indexed.

I'm glad to have this pointed...

Paul White NZ (4/20/2010)

---

Including the trivial case where the table has one row, if the rows in the table fit on a single page, SQL Server has a perfectly 'efficient'...

Thanks for the feedback, to all involved in this discussion so far.

I appreciate all the kind words and compliments. And I'l try to address the questions and criticism in the...

Hi Nigel,

Tough question. We can't really look in the minds of the developers...

nigel. (4/19/2010)

---

This is how I interpret the docs:

SCOPE_IDENTITY will return the identity value from the most recent insert in the current scope. If the most recent insert was to a...

Andrew Watson-478275 (4/19/2010)

---

A more interesting result is from this:

DECLARE @sid int

DECLARE @table Table (KeyID int primary key,KeyData varchar(5))

DECLARE @idtable Table (KeyID int identity primary key,KeyData varchar(5))

INSERT INTO @idtable (KeyData) VALUES('Test1')

INSERT...

Hi Tom,

I assume you...

Nice question, Ron. I do not agree with Jason about the importance of the information though - it is interesting to know, but absolutely irrelevant for our jobs. 😉

I do...

alexkedrov (4/15/2010)

---

john.arnott (4/15/2010)

---

steve block (4/15/2010)

---

I think it would have been delicious to have one of the options for the answer to be "I Don't Know" and it be the correct...

mtillman-921105 (4/13/2010)

---

Hugo Kornelis (4/13/2010)

---

mtillman-921105 (4/13/2010)

---

But I still wish that SQL would use it as a zero since in the real world when we add 5 + NULL we want to...

mtillman-921105 (4/13/2010)

---

But I still wish that SQL would use it as a zero since in the real world when we add 5 + NULL we want to see 5, not...