相關主題
商品描述
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.
Contents
Chapter 1: Structured Query Language
Chapter 2: An
Introduction to Using Jet SQL in Access
Chapter 3: An Introduction to
Relational Database Theory
Chapter 4: SQL Grammar
Chapter 5:
Retrieving Data
Chapter 6: Modifying Data
Chapter 7: Grouping
and Summarizing Data
Chapter 8: Creating and Modifying Tables
Chapter 9: Manipulating Relationships and Indexes
Chapter 10:
Advanced Manipulation Techniques
Chapter 11: Queries: The Sequel
Chapter 12: An Introduction to the SQL Server 2000 Desktop Engine
Chapter 13: Introduction to SQL Server
Chapter 14: SQL Server
Views
Chapter 15: SQL Server Structure
Chapter 16: Working with
Stored Procedures
Chapter 17: Upsizing Directly from Access
Chapter 18: Security Issues
Chapter 19: SQL Server Meets the Web
Appendix A: More SQL Solutions to Common Problems
Appendix B: An
Introduction to Using ADO and ADOX with SQL
