Sunday, September 17, 2006

SQLCLR more than in-process extended procedures

Ahh, finally theres another way to write extended stored procedure without diving into the C++ hell and guess what it runs in-process with SQL Server.

SQLCLR is the result of hosting the .NET Runtime into the SQL Server kernal so you can now write, deploy and run managed code.

imagin the power of leverage the .NET Class Library - you can't accsess all clasess eg. Widowns Forms, GDI+, etc - and the use of rich IDE like Visual Studio 2005.

finally SQLCLE is a great way to write stored procedures, user defind function, triggers and aggregations.

No comments: