|
SQL: Access to SQL Server
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.
Table of Contents:
Structured Query Language
Relational database theory
SQL grammar
Retreiving data
Modifying data
Grouping data
Creating data
Manipulating relationships
Queries
Introduction to the SQL Server 2000 desktop engine
SQL server views
SQL server architecture
Security issues
SQL SErver meets the web
|
