Appendix C: Views, Stored Procedures, and Triggers

In This Appendix

This appendix provides a discussion of views, stored procedures, and triggers, and the steps involved in their implementation inside SQL Server 2000. The main tools used in this chapter are the Query Analyzer and the Enterprise Manager.

Topics discussed are:

• The concepts of views, stored procedures, and triggers

• The usage of views, stored procedures, and triggers

• The implementation of views, stored procedures, and triggers using the Query Analyzer