HOUR 19. C# Special Topics

Just as there are special techniques available in Visual Basic .NET, these same techniques are available with C#. Using these techniques you can 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

By the Way

The code and text in this hour are very similar to the code and text found in Hour 17. The intention is to show you the similarities and differences between the Visual Basic .NET examples and the C# examples.

Temporary tables can be useful in certain situations. When you need them they are invaluable. ...

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.