OverviewWe've come a long way. In recent chapters, you've learned how to retrieve data from a database, and how to create, insert, modify, and delete the records that databases contain. In the next chapter, we'll begin to look at the place of ASP.NET code and databases in enterprise applications, but before that we have one more important subject to consider. We need to take a look at stored procedures.
Stored procedures are a key component of a client-server enterprise database system, providing many benefits for both performance and development. A stored procedure is a set of SQL statements that have been compiled into a single unit, and stored in the database they're intended to work with. It can be as simple as a single SELECT statement, or it can contain multiple statements that perform complex calculations and make updates to many tables. In this chapter, we'll examine:
|