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

Page 216
Image 216
Microsoft 9GD00001 manual Configuring Database Options, 193