March 2005
Intermediate to advanced
304 pages
19h 23m
English
Content preview from Visual Studio Hacks
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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.