Sql Interview Question: What is SQL CLR?

SQL CLR (SQL Common Language Runtime) is a technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft SQL Server environment.

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!