Advertisement

Temporary Tables

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

If you read most of this book (and we certainly hope you will), then you will be armed to handle most situations without having to resort to using temporary tables. Temporary tables do involve extra overhead, as well as extra programming effort. However, they are useful for doing work that requires multiple passes, to avoid doing repetitive work, or to do work that cannot be done any other way. They also allow you to simplify complex queries. SQL Server has had the capability of creating temporary tables since the Sybase days.

Keywords

Business Rule Table Variable Original Table Identity Column Extra Overhead 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Itzik Ben-Gan and Tom Moreau 2000

Authors and Affiliations

  • Itzik Ben-Gan
  • Tom Moreau

There are no affiliations available

Personalised recommendations