Well done, Gail.

Ok own up - who chose Pepsi? :laugh:

Sigh. Ticked all the 'new' data types except 'date' for some reason. Clearly having an off day.

SQL Server error handling is bizarre.

Hugo Kornelis (6/27/2012)

---

Second: It was never my intention to make this a wordplay or mindguessing game. I tried to cover all the possible unintended interpretations in the question. But I...

WayneS (7/1/2012)

---

All others: Ron (aka bitbucket) has contributed ~ 75 QotD questions, and this is the first one that I've seen from him with this level of confusion. Give him...

Getting my point back.

Yes. Error 539 is specific to SELECT...INTO, and the way it is implemented internally. ...

For anyone interested, here's a multi-character SQLCLR splitter based on Adam Machanic's code:

CREATE ASSEMBLY...

L' Eomot Inversé (6/20/2012)

---

Life has suddenly changed. Our daughter is in hospital and very unlikely to come out again. We originally thought it was something that that would...

The syntax is a bit weird to start with, but you get used to it eventually 🙂

Inserting, Updating, and...

iwaldner (6/13/2012)

---

I wonder why MSFT restricted the Output clause.. is there some technical reason why outputting from the "from" table wouldn't work, or is it just not part of the...

I always forget the last...

MyDoggieJessie (6/7/2012)

---

In the past someone created a CLR function that pulled out the proper field based upon its position within the extent, however, the source code for that is "lost"...

It's often a backward-compatibility thing.