SQL: Access to SQL Server [Paperback]

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.

This is the first book of its kind! Microsoft Access uses a specific dialect of SQL known as Jet SQL to communicate with the Jet Engine. This book shows you how to talk directly to the Jet, bypassing the query design window. Why would you want to? You can't really take advantage of all the Jet has to offer until you can speak its language. The first part teaches you the rules and syntax you'll need to master to talk Jet SQL. The second and third sections show you how to upside an Access database to an Access Project and discusses some of the changes the Access Developer will face when working with SQL Server, including Stored Procedures, Functions, and Views. These sections are full of helpful hints and warnings. Access SQL to SQL Server Desktop Edition and Beyond is more than just a comprehensive reference tool for Jet SQL. You'll also find efficient SQL solutions for common Access problems and tasks, in addition to helpful hints and warnings about what to avoid. Learning Jet SQL is al3&