O'Reilly logo

Sams Teach Yourself Microsoft SQL Server 2005 Express in 24 Hours by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required