Sams Teach Yourself SQL in One Hour a Day, Fifth Edition

LESSON 19Temporary Tables, Stored Procedures, Triggers, and Cursors

Over the course of the past 18 lessons, you have examined every major topic used to write powerful queries to retrieve data from a database. You have also briefly explored aspects of database design and database security. This lesson’s objective is to cover advanced SQL topics, which include the following:

• Temporary tables

• Cursors

• Stored procedures

• Triggers

• Embedded SQL

NOTE

This lesson’s examples use MySQL, Oracle, and Microsoft SQL Server’s Transact-SQL implementations. We made an effort to give examples using both flavors of SQL wherever possible. You do not need to own a copy of the SQL Server database product. Feel free to choose your database product based on ...