Ever find that that a stored procedure could use a makeover? Maybe a little
better performance is needed, or some custom business logic is required? The
answer..CLR stored procedures. Leverage the CLR (the Microsoft .NET Common
Language Runtime) and all that managed code has to offer. Managed code is
better suited than Transact-SQL for calculations and complicated execution
logic. With the functionality found in the .NET Framework Library, you have
access to thousands of pre-built classes and routines. In just a few clicks,
SQL.CLR can generate a CLR procedure in C# or VB.net, a compiled assembly
and a project for adding additional logic.
SQL.CLR generates CLR stored procedures and user defined functions from
existing procedures and functions in SQL Server. The stored procedure or user
defined function code can be generated in C# or VB.net, compiled into an
assembly and even create a Visual Studio project with the generated code.
