Advertisement

Other Data Manipulation Issues

  • Itzik Ben-Gan
  • Tom Moreau

Abstract

Tins chapter unveils some of the greatest features of SQL. A few of these are the result of SQL Server’s support for the ANSI-92 SQL standard. Others are specific to SQL Server. After reading this chapter, you will be able to take advantage of the CASE expression to build pivot tables in a single SELECT; roll your own sort order or do updates without the need for temporary tables; use TOP n queries; master logical operations and bitwise manipulation; and handle dates in any way, shape, or form.

Keywords

Truth Table Logical Expression North American Free Trade Agreement Parity Information Sort Order 
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