Stored Procedures and Views
Relational databases such as SQL Server and Oracle rely on stored procedures to do repetitive tasks, so a programmer’s main jobs when creating database applications are creating, debugging, and testing stored procedures (often called stored procs). Another database object it behooves programmers to learn is the view—or virtual table. In this chapter, you’ll learn how to take advantage of Visual Studio.NET (VS.NET) tools to work with both stored procedures and views.
Unable to display preview. Download preview PDF.