I got it wrong because I paid too much attention to the function and didn't pay any attention to the parameter value passed in :blush:

But I've definately seen this...

This is true for T-SQL...

Because CLR assemblies are not compiled to machine language there is no problem when moving them between 32 and 64 bit. The assemblies will be JIT compiled by the runtime...

cs_troyk (5/13/2008)

---

Regarding string splitting in CLR vs. T-SQL, check out Paul Nielsen's blog. One of his lessons learned is exactly this issue: http://sqlblog.com/blogs/paul_nielsen/archive/2007/12/12/10-lessons-from-35k-tps.aspx

Would be interesting to see how...

Matt,

Thanks for that article link. I seem to remember seeing a tally table at some point when I first started programming, but didn't understand it, moved on and forgot about...

Yeah, comparing CLR w/ XML wasn't really the...

Splitting a string may be trivial in T-SQL but that doesn't mean it's the best tool for the job. The CLR is vastly faster for splitting strings the longer your...

You cannot use UI components from w/in the SQL CLR.

The CLR uses host protection attributes (HPAs) which declare information about what specific framework classes and methods do. This allows the...