1. Create Project of Type DataBase and select SQL Server in the Project Template.
2. Add an item of type User-Defined Functions.
3. Write your code.
4. Select Build ? Deploy <your projectName>
1. If you have not enabled the CLR in SQL Server 2005. Before you have to enable the CLR in the SQL Server 2005.
1. This can be done by executing the following statements in Query Window of SQL Server 2005.

EXEC sp_configure 'clr enabled' , 1 Go
reconfigure;
Then select Deploy Option from the menu.

Creating Database Project

1. Go to File --> Project
2. Select the project type as Database and Template as SQL Server Project


1. 
3. In the next step you will be prompted to create a connection. You will get a popup window to select one connection or create a new connection for this project. I made use of my Local SQL Server Express database and selected NORTHWIND as the database.
1. 
4. Then right click the project and select Add ? User-Defined Functions.
1. Select User Defined Function under Visual Studio Installed Templates.
2. 
   
5. I just named the CS file as Add3Numbers.



    	[Microsoft.SqlServer.Server.SqlFunction]
    	public static SqlInt32 Add3Numbers(int firstNumber, int secondNumber, int thirdNumber)
    {
        return firstNumber + secondNumber + thirdNumber;
    }




6. Build the application to make sure that it’s compiling successfully.
7. Then, select Build ? Deploy <yourprojectName>
8. It will deploy the function successfully. You can try running the following query in Management Studio.
   1. Login to the SQL Server and select the database which you have used to create a connection and run the following statement.
   2. select dbo.Add3Numbers(20,30,40)
   3. You will get a following error if CLR is not enabled
   
   Msg 6263, Level 16, State 1, Line 1
   Execution of user code in the .NET Framework is disabled. Enable "clr enabled" configuration option.
   4. You have to run the following statement to execute the function. This has to be executed in Query Window of SQL Server 2005.
   1. EXEC sp_configure 'clr enabled' , 1
   5. This will enable the CLR in SQL Server 2005.
   6. Then execute [B]select dbo.Add3Numbers(20,30,40)[/B]

Attachments