Developing and Deploying SQL Sever Apps on Windows Integrity

17 of 39
9. Right-click Solution Explorer, select Add, then New Item, then Stored Procedure.
Select a name for the stored procedure. Click OK.
10. Write the code in the Visual Studio project window as shown below. This example is a
simple Hello World program.
11. From the project’s Build Menu, select Build Solution. The status window at the
bottom of the screen shows the activities.
12. If there are build errors, they will be displayed. On Debug menu, set the break points
and start debugging the solution as you normaly do for x86 and x64 platforms.
13. You can also use the solution explorer’s Test Scripts to validate the code. Detailed
information about debugging SQL CLR
database objects is available at Microsoft web
site.
14. From the Build menu, rebuild the solution, then select Deploy Solution. The
HelloWorld stored procedure will be deployed to the Integrity Server.