Use Table-Valued Functions as Arrays in SQL Server
Next, I plan on writing a series of articles on the SQL CLR discussing the following topics:
- CLR Security
- CLR Performance/Stability
- CLR vs T-SQL
- CLR Best Practices
I've almost finished the first article on security, it's been very enlightening. Code Access Security is really a big part of how SQL Server is able to host the CLR in a secure and stable environment. I'm really amazed at how the CLR was designed in such a way that allows it not only to be hosted that any application that wants to take advantage of the CLR, but also at the way it allows the host to restrict unwanted functionality.