HOUR 17. Visual Basic .NET Special Topics
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
Working with Temporary Tables
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 ...
Get Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.