.NET CLR stored procedures in SQL Server 2005 DB: Good News for Programmers, Shock for DBAs - Deploying and testing SQL Server 2005 based .NET CLR stored procedure using Visual Studio 2005

(Page 4 of 5 )

Once you complete all of the steps in the previous section, proceed with the following steps to deploy the .NET CLR based stored procedure using Visual Studio 2005.

·         Press Ctrl+Alt+L to open “Solution Explorer”

·         Right click on and select “Deploy” (shown in Fig8)

·         The program starts building your solution and finally deploys it.  While the process is going on, you need to observe the status bar of Visual Studio IDE.  Once you complete deployment, the status bar should look something like the following image (Figure 9).

To execute the .NET CLR stored procedure from within Visual Studio 2005, open “Solution Explorer” from “View” menu, open “Test Scripts” and open “Test.sql”.  Go down to the last line of the same file and modify as shown in Figure 10.

Finally, press F5 to execute the solution.  The program rebuilds it, deploys it and executes your “test.sql”.  Now you can check your “emp” table in the database, which gets all values of “sal” column incremented by 100 as shown in the following Fig 11.

Next: When to use .NET >>
 

More MS SQL Server Articles
More By Jagadish Chaterjee

Comments On: .NET CLR stored procedures in SQL Server 2005 DB: Good News for Programmers, Shock for DBAs

· Hello guys! Earlier, I contributed .NET stored procedures for Oracle 10g on the same...   >>> Post your comment now!