sql stored procedures

National University of Computer and Emerging Sciences

Lab Manual 8
“Views and Stored Procedures (Advanced Concepts)” Database Systems

Lab Instructor(s)
Anam Mansoor
Semester
Spring 2014

Department of Computer Science
FAST-NU, Lahore, Pakistan

Table of Contents

1. Task Distribution

Total (170 minutes) Views (35 minutes)
Stored Procedures (Advanced Concepts) (35 minutes)
In lab Exercise (60 minutes)
Phase 2 Evaluations (30 minutes)

2. Objective

In this lab, the concept of views will be discussed along with its implementation and types. We will also go through introduce some advance usage of stored procedures. At the end of this lab, you will have knowledge of the following.

Views.
Advanced Concepts of stored procedures.

3. Views
“A database view displays one or more database records on the same page. A view can display some or all of the database fields. Views have filters to determine which records they show. Views can be sorted to control the record order and grouped to display records in related sets. Views have other options such as totals and subtotals.
Most users interact with the database using the database views. A key to creating a useful database is a well-chosen set of views. Luckily, while views are powerful, they are also easy to create.”
A View is a "Virtual Table". It is not like a simple table, but is a virtual table which contains columns and data from different tables (may be one

References: 1. http://www.mssqltips.com/sqlservertutorial/160/sql-server-stored-procedure/