Views and Stored Procedures

In this chapter, we will work with advanced Data Definition Language statements that are used for creating, altering, and deleting two special objects known as views and stored procedures. These objects are used to perform various query operations. Views are like Access Select queries, however you can't use the ORDER BY clause to sort your data or use parameters to filter records. Stored procedures perform the same operations as Access Action and Parameter queries. They can also be used for creating sorted Select queries. Stored procedures are saved precompiled so that at run time the procedure executes much faster than standard SQL. Learning how to create and use views and stored procedures will give you more control over your database.

0 0

Post a comment