Other Data Manipulation Issues
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.
KeywordsTruth Table Logical Expression North American Free Trade Agreement Parity Information Sort Order
Unable to display preview. Download preview PDF.