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...

Full description

Bibliographic Details
Main Author:	Harkins, Susan Sales
Corporate Author:	SpringerLink (Online service)
Other Authors:	Reid, Martin W. P.
Format:	eBook
Language:	English
Published:	Berkeley, CA : Apress, [2002]
Series:	Expert's voice Books for professionals by professionals
Subjects:	SQL server > Handbooks, manuals, etc. SQL server. SQL (Computer program language) > Handbooks, manuals, etc. Relational databases. Database management > Computer programs. SQL. Databanken. SQL (Computer program language) Electronic books. Handbooks, manuals, etc.
Online Access:	Connect to the full text of this electronic book

Table of Contents:

Chapter 1 Structured Query Language 1
Chapter 2 An Introduction to Using Jet SQL in Access 7
Chapter 3 An Introduction to Relational Database Theory 35
Chapter 4 SQL Grammar 69
Chapter 5 Retrieving Data 83
Chapter 6 Modifying Data 133
Chapter 7 Grouping and Summarizing Data 169
Chapter 8 Creating and Modifying Tables 199
Chapter 9 Manipulating Relationships and Indexes 215
Chapter 10 Advanced Manipulation Techniques 233
Chapter 11 Queries: The Sequel 253
Chapter 12 An Introduction to the SQL Server 2000 Desktop Engine 279
Chapter 13 Introduction to SQL Server 307
Chapter 14 SQL Server Views 371
Chapter 15 SQL Server Structure 397
Chapter 16 Working with Stored Procedures 441
Chapter 17 Upsizing Directly from Access 493
Chapter 18 Security Issues 541
Chapter 19 SQL Server Meets the Web 585
Appendix A More SQL Solutions to Common Problems 655
Appendix B An Introduction to Using ADO and ADOX with SQL 667.