Difference between revisions of "CLR Support - MS SQL"

Revision as of 16:36, 1 November 2013

This page discusses support for the CLR in MSSQL.

What is the CLR

CLR stands for "Common Language Runtime". This is the runtime that executes .Net code. The CLR integration within MSSQL allows functions written in .Net code to be integrated with your SQL queries and stored procedures.

Using the built-in SQL language to form queries will generally give you better performance than using the CLR as MSSQL is highly optimized for use with SQL. However, there are some table structures, such as hierarchies and XML, that can be complicated to work with using traditional SQL as compared with .Net.

Is the CLR supported?

The CLR is supported for Dedicated/VPS servers only. We do not currently support the CLR on our shared hosting servers.

If I am using shared hosting, what options do I have?

Since we do not support the CLR in MS SQL on our shared servers, you will need to pull the data into a local dataset in your application code to run any .net code on it. This can be less efficient for code that works on a large rowset since it has to bring those rows over the network from the SQL server to the web server, but it will give you similar capabilities for working with the data using the .Net runtime.

Davidd (talk) 11:35, 1 November 2013 (CDT)