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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2000 Itzik Ben-Gan and Tom Moreau
About this chapter
Cite this chapter
Ben-Gan, I., Moreau, T. (2000). Other Data Manipulation Issues. In: Advanced Transact-SQL for SQL Server 2000. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0859-4_4
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0859-4_4
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-893115-82-8
Online ISBN: 978-1-4302-0859-4
eBook Packages: Springer Book Archive