Advertisement

SQL: Access to SQL Server

  • Authors
  • Susan Sales Harkins
  • Martin W. P. Reid

Table of contents

  1. Front Matter
    Pages i-xix
  2. Susan Sales Harkins, Martin W. P. Reid
    Pages 1-5
  3. Susan Sales Harkins, Martin W. P. Reid
    Pages 7-34
  4. Susan Sales Harkins, Martin W. P. Reid
    Pages 35-68
  5. Susan Sales Harkins, Martin W. P. Reid
    Pages 69-82
  6. Susan Sales Harkins, Martin W. P. Reid
    Pages 83-132
  7. Susan Sales Harkins, Martin W. P. Reid
    Pages 133-168
  8. Susan Sales Harkins, Martin W. P. Reid
    Pages 169-198
  9. Susan Sales Harkins, Martin W. P. Reid
    Pages 199-213
  10. Susan Sales Harkins, Martin W. P. Reid
    Pages 215-232
  11. Susan Sales Harkins, Martin W. P. Reid
    Pages 233-252
  12. Susan Sales Harkins, Martin W. P. Reid
    Pages 253-278
  13. Susan Sales Harkins, Martin W. P. Reid
    Pages 279-306
  14. Susan Sales Harkins, Martin W. P. Reid
    Pages 307-370
  15. Susan Sales Harkins, Martin W. P. Reid
    Pages 371-395
  16. Susan Sales Harkins, Martin W. P. Reid
    Pages 397-440
  17. Susan Sales Harkins, Martin W. P. Reid
    Pages 441-492
  18. Susan Sales Harkins, Martin W. P. Reid
    Pages 493-539
  19. Susan Sales Harkins, Martin W. P. Reid
    Pages 541-583
  20. Susan Sales Harkins, Martin W. P. Reid
    Pages 585-653
  21. Back Matter
    Pages 655-700

About this book

Introduction

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.

Keywords

ADO Access SQL Database SQL SQL Server 2000 SQL server XML relational database

Bibliographic information