June 2006
Beginner
456 pages
10h 3m
English
You can use some special techniques to write more robust and powerful stored procedures. In this hour you’ll learn
• How to work with temporary tables
• How to add error handling to your stored procedures
• How to use transaction processing within your stored procedures
Temporary tables can be useful in certain situations. When you need them they are invaluable. A temporary table can contain data from heterogeneous data sources (even a text file). Using temporary tables, you have access to methods that facilitate data access and retrieval. These methods enable you to sort, filter, index, and select a table’s rows.
The stored procedure found in Listing 17.1 first opens ...
Read now
Unlock full access