Implementing Managed code in SQL Server 2005 using Visual Studio.NET 2005 - Executing the Managed Code from Visual Studio 2005

(Page 4 of 5 )

There are several ways to execute the CLR-based stored function. You can execute it from Visual Studio.NET 2005 or even from SQL Server Management Studio.  But in this article, we concentrate on Visual Studio.NET 2005 for execution.

Method 1

If we carefully examine the solution explorer (within the same project "SampleSqlServerProject" of Visual Studio), we should be able to see a special folder named "TestScripts." This folder gets automatically created by Visual Studio with some sample script in "Test.sql" file within the same folder. You can use this file to really test your managed code. It basically contains T-SQL commands to test the managed code. Make changes to the code in "Test.sql" as follows:

selectdbo.getEmployee('1002')

Go to the next line, right click and select "Run to Cursor."  This again deploys and executes the script (Fig 6). 

You should be able to see your output in the output window as follows (Fig 7).

Method 2

Press Ctrl+Alt+S to show server explorer and open Data Connections >> <instance.emp.dbo> >> functions >> getEmployee

Right click on "getEmployee" and select execute (Fig 8).

You will be presented with a "Run Function" dialog that has a grid of parameters. Type "1002" in the value column and press OK (Fig 9). If you examine the output window, it should be similar to the output in Fig 7.

Next: Transact SQL vs. Managed Code >>
 

More MS SQL Server Articles
More By Jagadish Chaterjee

Comments On: Implementing Managed code in SQL Server 2005 using Visual Studio.NET 2005

· It is a very good article to start with.The tabular difference between managed and...   >>> Post your comment now!