With the functionality found in the .NET base class libraries, you have access to thousands of pre-built classes. Extending the functionality of your stored procedures and user defined functions has never been easier.
Generate compiled assemplies for deploying later
Generate SQL database projects option
Easily incorporate version control with generated code
Implement code in C# and VB.NET
...and more!
Access to data structures like arrays and lists can perform significantly better due to different execution models of CLR and T-SQL.
SQL.CLR Standard Edition Generate CLR stored procedures and functions from existing procedures and functions in SQL Server. The code can be generated in C# or VB.net, compiled into an assembly and even create a Visual Studio SQL Server project with the generated code. See a Feature Comparison for more details.
SQL.CLR Standard 2008 Edition Generate CLR stored procedures and functions from existing procedures and functions in SQL Server. The code can be generated in C# or VB.net, compiled into an assembly and even create a Visual Studio SQL Server project with the generated code. See a Feature Comparison for more details.
SQL.CLR Professional Edition Generate CLR stored procedures and functions, but allows for multiple objects to be generated at a time. Convert all your procedures in a database with 1 click. See a Feature Comparison for more details.
SQL.CLR Professional 2008 Edition Generate CLR stored procedures and functions, but allows for multiple objects to be generated at a time. Convert all your procedures in a database with 1 click. See a Feature Comparison for more details.