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 Acces...
| Main Authors: | , |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Berkeley, CA
Apress
2002, 2002
|
| Edition: | 1st ed. 2002 |
| Subjects: | |
| Online Access: | |
| Collection: | Springer Book Archives -2004 - Collection details see MPG.ReNa |
Table of Contents:
- 1: Structured Query Language
- 2: An Introduction to Using Jet SQL in Access
- 3: An Introduction to Relational Database Theory
- 4: SQL Grammar
- 5: Retrieving Data
- 6: Modifying Data
- 7: Grouping and Summarizing Data
- 8: Creating and Modifying Tables
- 9: Manipulating Relationships and Indexes
- 10: Advanced Manipulation Techniques
- 11: Queries: The Sequel
- 12: An Introduction to the SQL Server 2000 Desktop Engine
- 13: Introduction to SQL Server
- 14: SQL Server Views
- 15: SQL Server Structure
- 16: Working with Stored Procedures
- 17: Upsizing Directly from Access
- 18: Security Issues
- 19: SQL Server Meets the Web
- Appendix A: More SQL Solutions to Common Problems
- Problem 1: Begin a Label Report at Any Label on the Sheet
- Problem 2: Finding the Second-Highest or -Lowest Value in a Group
- Problem 3: Adding a Summary Row to a Query
- Problem 4: Returning Alternating Rows
- Problem 5: Producing a Random Sort
- Problem 6: Counting Specific Entries
- Problem 7: Counting Unique Values
- Problem 8: Finding Unique Values
- Problem 9: Displaying Optional Data in a List Control
- Problem 10: Custom Sort for Controls
- Appendix B: An Introduction to Using ADO and ADOX with SQL
- Microsoft ActiveX Data Objects Library (ADO)