Paul, thanks for the feedback....

Hello Sander. I did just try that with the same table and data...

rlobbe (2/11/2010)

---

With 2005/2008 it's easy to create unlimited version of string functions via CLR (C# etc) what annoyed me was way you had to do it. SqlString needs a [SqlFacit(maxlength=-1)]...

Paul, thanks for the great compliment as well as the code and explanation of it. I think it will be very helpful to many people.

Barry, hopefully you can get...

Hello again Per. I found this, which seems related but might not be the same issue since you say that you closed the connection before returning:

http://social.msdn.microsoft.com/Forums/en-IE/sqlnetfx/thread/e9e7c707-87fb-49cc-bd0b-d426ed53a534

For now, I would...

perh (1/4/2010)

---

I have tried using the yield return method in one of my test projects but I am getting the error below:

"An error occurred while getting new row from...

Jeff Moden (12/25/2009)

---

Not sure you need the minor overhead of RegEx for such a thing either but, being pretty much a hard core data troll, I've not worked outside SQL...

RBarryYoung (12/24/2009)

---

However, "yield break" is another story altogether. I have not heard of any way by anyone of a way to emulate a "yield break" in Vb other than the...

Jeff Moden (12/24/2009)

---

The files also had "file headers" and "file footers". Heh... while everyone else was pitching a fit, I used the information in those to confirm what was...

Jeff Moden (12/24/2009)

---

That's one of the problems that I seem to see popping up a lot... CLR's running the system out of memory. I've not asked any DBA in...

RBarryYoung (12/24/2009)

---

Actually, Jeff, the line-splitting functions and (less often)parsing functions are usually best done as TVF's, whether SQL or CLR. Unfortunately, as Matt pointed out, CLR TVF's by default...

As a side bar, Matt Miller and I had some friendly races a couple/three years ago on Regex and the results came out pretty close in a lot of the...

Jeff Moden (12/23/2009)

---

Next question, please... What application would have the need for such a thing where it could not be done using T-SQL? Not trying to be a...

Besides the speed - I'd anticipate this also reduces the memory footprint as well - have you had any exposure to this (it should be smaller since the entire recordset...

Well, not quite true. ...