cfradenburg (10/25/2012)

---

Kenneth.Fisher (10/22/2012)

---

Does anyone think I should go ahead and add this as a follow up QOTD? Or do one about reseeding causing a duplicate identity? Or not...

"Eid Mubarak" Jamsheer 🙂

Thanks for this question Ron. I was little confused when I saw this phrase "USING SQL SERVER 2012" 🙂

I think PARSENAME result will remain same for SS2005, SS2008, SS2008 R2...

Primo Dang (10/23/2012)

---

WayneS (10/23/2012)

---

So, we're now recommending building duplicate foreign keys?

Personally, I thought that this...

call.copse (10/23/2012)

---

I liked this question, as I wondered whether anyone would try running the sample code, and what would happen if they did (and I got it right comfortably!). Would...

This is the recommended maximum limit, but you can have infinite number of FK constraints in...

kapil_kk (10/22/2012)

---

Execute this code and you will get duplicate values in Identity values--

CREATE TABLE IdentTest

( Ident INT NOT NULL IDENTITY (1,1)

, varfield varchar(100)

)

INSERT INTO IdentTest VALUES ('xyz') --...

kapil_kk (10/22/2012)

---

in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert statement the ident value...

kapil_kk (10/22/2012)

---

in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert statement the ident value...

john.arnott (10/21/2012)

---

Good topic for a follow-up QOD (hope I don't steal any thunder here):

If the code presented had one more statement amnd asked for the max(Ident)...

CREATE TABLE IdentTest

( Ident...

Very nice question indeed. Guess what sould be the output of the last select statement, If I add a TRUNCATE statement in the code as well:

CREATE TABLE IdentTest

( Ident...

Thanks Ravi....was new for me. Was not aware that result can be "**" 🙂

kapil_kk (10/17/2012)

---

But the query that you pasted is just simply give the first non null value as the coalesce does and give output as 'NULLFail'.... 😛 (no tricks in it)

today's...

You are welcome 🙂

philip.cullingworth (10/17/2012)

---

To me this feels more like a trick question than a question about coalesce. The trick was to notice that 'NULL' was quoted and not the NULL value....