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
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/