The .NET framework can run managed code because it has the CLR. If SQL Server wanted to run managed code in its own environment, it would need its own .NET runtime.
The SQL CLR is the engine SQL Server uses to run .NET code.
In SQL Server 2005 and beyond, SQL Server objects such as user-defined functions can be created using such CLR languages.
This CLR language support extends not only to user-defined functions, but also to stored procedures and triggers. You can develop such CLR add-ons to SQL Server using Visual Studio.
Thanks for reading this article,
Next steps :
1. Share this with your colleagues because Sharing is Learning
2. Comment below if you need any assistance
Powered by CodeReview – Let’s make it Better!