Overview
Includes a handy appendix with a table comparing Jet SQL, Access SQL, and SQL Server's T-SQL; another appendix contains "ready-to-run solutions"
Features time-saving information on upsizing from Access to SQL Server
Shows how to leverage new features in Access 2002 when working with SQL
Includes supplementary material: sn.pub/extras
Access this book
Tax calculation will be finalised at checkout
Other ways to access
Table of contents (19 chapters)
-
Front Matter
Keywords
About this book
SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. You'll also find efficient SQL solutions for common Access problems and tasks, as well as helpful hints and warnings about what to avoid. Learning Jet SQL is an important step from just using Access to developing with Access.
In addition to learning Jet SQL, readers will embark on a journey into the world of SQL Server 2000. The journey starts when you learn how to install SQL Server and ends with an introduction to XML and ASP. Along the way, using Access Data Projects, you'll see features new to SQL Server 2000, including functions that return tables, instead of triggers and gotchas with upsizing. The authors highlight not only the enormous opportunities awaiting you as an Access developer, but also the potential challenges and pitfalls you may face as you move from Access to SQL Server 2000.
About the authors
Bibliographic Information
Book Title: SQL
Book Subtitle: Access to SQL Server
Authors: Susan Sales Harkins, Martin W. P. Reid
DOI: https://doi.org/10.1007/978-1-4302-1573-8
Publisher: Apress Berkeley, CA
-
eBook Packages: Springer Book Archive
Copyright Information: Susan Sales Harkins and Martin Reid 2002
Softcover ISBN: 978-1-893115-30-9Published: 29 January 2002
eBook ISBN: 978-1-4302-1573-8Published: 25 June 2008
Edition Number: 1
Number of Pages: XIX, 698
Topics: Database Management, Software Engineering/Programming and Operating Systems