.NET CLR Programming with SQL Server 2005 Made Simple - .NET CLR stored procedure in SQL Server 2005 database: Testing
(Page 4 of 6 )
To test the above stored procedure, follow the following steps:
- Using “Solution Explorer,” open “test.sql” in “test scripts” (Fig 11).
- Go to the last line and modify the code as follows:
--select 'To run your project, please edit the Test.sql file in
your project. This file is located in the Test Scripts folder in
the Solution Explorer.'
exec IncSalaries 50
- Go to Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Surface Area Configuration.
- Within the window, click on “Surface Area Configuration for Features” (Fig 12).
- Enable the CLR integration as shown (Fig 13).
- Press F5 to execute the whole solution. If it executed with any errors, everything gets displayed in the “Output” window.
- If the stored procedure executes successfully, you should be able to see all the salaries increased by 50.
Next: .NET CLR user-defined function in SQL Server 2005 database >>
More MS SQL Server Articles
More By Jagadish Chaterjee
