cppprogrammer (11/24/2014)

---

Thank you very much for your response.

Solomon Rutzky (11/23/2014)

---

CLR is the most direct route, though could be a SQLCLR stored procedure (or function) that is called from a T-SQL...

cppprogrammer (11/23/2014)

---

Hi,

I'm investigating viable solutions to the following problem. A 3rd party is inserting data into a database we own. Currently I do not know if they have a method...

Well, there is something to be said about reducing round-trips, but that is not exactly what this author is talking about. His statement of

one of the simplest things you can...

David.Poole (9/12/2014)

---

I had a lot of fun reading the drafts of these articles and they both opened my eyes and dispelled quite a few misconceptions.

I wish I had known everything...

fregatepllada (9/11/2014)

---

halifaxdal (9/5/2014)

---

Nice article and nice experiment, but unfortunately from security perspective I am not able to even give the needed SQL# a try simply because SQL# has lots highly...

boumerlin (9/11/2014)

---

I did have some time to look at the SQL# code. I assume that the hex in create assembly statements are the actual assemblies themselves, meaning there is no...

No problem....

amilapradeep (8/14/2014)

---

I am experiencing the same issue right now.

scenario is same as your. but if web service and SQl server are on same machine, then it works fine (so...

copling (9/10/2014)

---

Mr. Solomon, I really enjoyed your article in regards to External and Unsafe security framework for SQLCLR. I've really been interested in utilizing the power that this piece of...

TomThomson (9/10/2014)

---

Steve Jones - SSC Editor (9/10/2014)

---

Jeff Moden (9/10/2014)

---

Heh... yeah... just like they gave us the ability to...

Jeff Moden (9/5/2014)

---

Heh... MS should stop inventing new things, stop deprecating old things, and start making things work / adding practical things. For example, the CONNECT item to create...

halifaxdal (9/5/2014)

---

Nice article and nice experiment, but unfortunately from security perspective I am not able to even give the needed SQL# a try simply because SQL# has lots highly restricted...

Eirikur Eiriksson (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Hi Sean. In the case of:

Bob,Sally,

The result should be 3 records:

Bob

Sally

{empty string}

A NULL cannot be there as it was a non-NULL string that was split....

Sean Lange (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Eirikur, I completely agree with the statements of "just think how much is going to fail down the line if suddenly NULLs become empty strings" and...

Lynn Pettis (9/4/2014)

---

Solomon Rutzky (9/4/2014)

---

Second, this shouldn't be controversial since a NULL concatenated into a non-NULL string will (well, should) result in a NULL. This behavior can be changed via...