.NET CLR Programming with SQL Server 2005 Made Simple - .NET CLR stored procedure in SQL Server 2005 database: creation (Page 2 of 6 ) Once you have created the database and tables as shown in the previous section, complete the following steps to create a .NET CLR stored procedure in a SQL Server 2005 database: - Go to Start -> Programs -> Microsoft Visual Studio 2005 -> Microsoft Visual Studio 2005.
- Go to File -> New -> Project.
- Within the “New Project” dialog box, select "database" for the "Project Type" in the “Visual Basic” tree and select “SQL Server Project” as the template. Provide the name “SampleAllInOne.” By this time, the dialog box should look something like the following (Fig 6).
- Once you click “OK”, you will be provided with the “New Database Reference” dialog. Provide your own instance name, select the database “Sample” (created in previous section) and test the connection (Fig 7).
 - Once testing is successfully completed, click on “OK” to create the project.
- You will be provided with a dialog box, which asks you to enable CLR debugging or not. Please click on “Yes” for that (Fig 8).
 - Using the “Solution explorer,” right click on the “SampleAllInOne” Project, and go to Add-> Stored Procedure (to create a new stored procedure) (Fig 9).
 - You will be presented with the “Add New Item” dialog box. Within that dialog box, select “Stored Procedure” as template and provide the name as “IncSalaries” and finally click on “Add” (Fig 10).
Next: .NET CLR stored procedure in SQL Server 2005 database: Coding >>
More MS SQL Server Articles
More By Jagadish Chaterjee |
