Abstract
Structured query language (SQL) is the lingua franca of relational databases, and a solid understanding of it is not optional. SQL is also the ultimate report writer and usually allows you to extract your data exactly in the format that you want it to print. This chapter reviews general SQL syntax and how it varies from one relational database management system (RDBMS) to another. Though most of the SQL examples in this chapter are run against the Northwind database that ships both with Microsoft SQL Server 2000 and Microsoft Access, we’ll also examine dialects of SQL particular to Microsoft Access 2000, Oracle 8, and Sybase 12.
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
© 2003 Carl Ganz, Jr.
About this chapter
Cite this chapter
Ganz, C. (2003). Introducing SQL and ADO. In: Real World Enterprise Reports Using VB6 and VB .NET. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-0770-2_2
Download citation
DOI: https://doi.org/10.1007/978-1-4302-0770-2_2
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-064-5
Online ISBN: 978-1-4302-0770-2
eBook Packages: Springer Book Archive