Skip to Main Content
Visual Studio Hacks
book

Visual Studio Hacks

by James Avery
March 2005
Intermediate to advanced content levelIntermediate to advanced
304 pages
19h 23m
English
O'Reilly Media, Inc.
Content preview from Visual Studio Hacks
Diagram and Modify a Database #74
Chapter 9, Server Explorer Hacks
|
305
HACK
Just as with tables, you can design a view by right-clicking on it and choos-
ing Design View. The design view is shown in Figure 9-12.
Much like the table designer, the view designer is very similar to the one in
Enterprise Manager. You can also add triggers to the view by right-clicking
on the view and clicking Add Trigger.
Stored Procedures
Support for stored procedures is one area in which the Server Explorer
excels. The Server Explorer displays not only the name of the stored proce-
dure, but also includes a list of the parameters and return columns from the
stored procedure. This node is shown in Figure 9-13.
From the Server Explorer, you can create new stored procedures, edit stored
procedures, and even run them. By right-clicking on the stored procedure
and choosing Run Stored Procedure, you will then see the parameters dia-
log shown in Figure 9-14.
Figure 9-9. Server Explorer Tables interface
306
|
Chapter 9, Server Explorer Hacks
#74 Diagram and Modify a Database
HACK
Figure 9-10. Table data view
Figure 9-11. Table design window
Diagram and Modify a Database #74
Chapter 9, Server Explorer Hacks
|
307
HACK
Figure 9-12. Design ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft Visual Studio 2015 Unleashed, Third Edition

Microsoft Visual Studio 2015 Unleashed, Third Edition

Mike Snell, Lars Powers
.Net Framework Essentials

.Net Framework Essentials

Thuan L. Thai, Hoang Lam
C# 5.0 Unleashed

C# 5.0 Unleashed

Bart De Smet
Programming .NET Security

Programming .NET Security

Adam Freeman, Allen Jones

Publisher Resources

ISBN: 0596008473Errata Page