
Chapter 7: Working with Data | 193 |
To execute this stored procedure,
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,
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