Page 215 - Open Soource Technologies 304.indd
P. 215
Open Source Technologies Mandeep Kaur, Lovely Professional University
Notes Unit 13: Stored Procedure
CONTENTS
Objectives
Introduction
13.1 Transactions
13.1.1 Properties of Transactions
13.1.2 COMMIT and ROLLBACK
13.1.3 Row-Level Locking
13.2 Stored Procedures
13.2.1 Implementation
13.2.2 Other Uses
13.2.3 Comparison with Dynamic SQL
13.2.4 Comparison with Functions
13.2.5 Disadvantages
13.3.6 Why Use Stored Procedures?
13.2.7 Creating a Stored Procedure
13.2.8 Calling a Stored Procedure
13.2.9 Specifying Parameters
13.2.10 Data Retrieval
13.2.11 Inserting Data Using Parameters
13.2.12 Benifits of Stored Procedures
13.3 Summary
13.4 Keywords
13.5 Self Assessment Questions
13.6 Review Questions
13.7 Further Reading
Objectives
After studying this unit, you will be able to:
• Explain transactions.
• Understand stored procedures.
210 LOVELY PROFESSIONAL UNIVERSITY
