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

Europe Trench Lost Romania Summing 

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