As I discussed in my previous
article, CLR is the heart of Microsoft .Net framework. In SQL Server
2005 we can create a database object inside an instance of SQL Server that
programmed in an assembly created by .Net framework. Assemblies are DLL files
used in an instance of SQL Server to deploy functions, stored procedures,
triggers, etc. that are written in one of the managed code languages hosted by
Microsoft .NET Framework.
In this article I am going to discuss how to use Visual
Studio 2005 for creating CLR integrated functions. In Visual Studio 2005 there
is an option for creating database projects, which is very helpful in this
Let us go through an example with creating CLR integrated
functions using Visual Studio 2005 and debugging it.