Common Language Runtime (CLR) objects can be used to extend SQL Server’s functionality by running managed code in the database engine. It’s really powerful. It can also be fun and dangerous, as you’ll see soon. If you are unfamiliar with SQL Server CLR, take a look at my previous post for a quick primer. In […]
Month: September 2020
How to create a SQL Server CLR function
Sometimes you need to write a SQL query that you know is going to be really ugly, or you may need to do something that SQL doesn’t support natively. Common Language Runtime (CLR) functions can help in these types of situations. This is a bit of a contrived example, but I have a real-world need […]