Filter
Top Products
Chapter 7: Working with Data 193
To execute this stored procedure, right-click the stored procedure in the database in
Server Explorer and click Execute. You’ll see output similar to the following if there are
records in the customer table:
Running [dbo].[GetCustomers].
Name
--------------------------------------------------
Meg
Joe
May
No rows affected.
(3 row(s) returned)
@RETURN_VALUE = 0
Finished running [dbo].[GetCustomers].
In addition to execution, you can debug the stored procedure in VS. To debug, set a
breakpoint on any line in the stored procedure, right-click the stored procedure in Server
Explorer, and select Step Into Stored Procedure or click
ALT-F5. If you need more help
debugging, visit Chapter 6 for a refresher on VS debugging capabilities.
Configuring Database Options
VS has many database configuration settings that you can view via the Tools | Options
menu and selecting Database Tools, as shown in Figure 7-10. For example, one of the
Figure 7-10 Database Tools options