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

Main Authors: Harkins, Susan Sales, Reid, Martin W. P. (Author)
Corporate Author: SpringerLink (Online service)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2002, 2002
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
LEADER 02876nmm a2200301 u 4500
001 EB000616329
003 EBX01000000000000000469411
005 00000000000000.0
007 cr|||||||||||||||||||||
008 140122 ||| eng
020 |a 9781430215738 
100 1 |a Harkins, Susan Sales 
245 0 0 |a SQL: Access to SQL Server  |h Elektronische Ressource  |c by Susan Sales Harkins, Martin W. P. Reid 
260 |a Berkeley, CA  |b Apress  |c 2002, 2002 
300 |a XIX, 698 p  |b online resource 
505 0 |a 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 Entri 
653 |a Computer science 
653 |a Software engineering 
653 |a Computer Science 
653 |a Software Engineering/Programming and Operating Systems 
700 1 |a Reid, Martin W. P.  |e [author] 
710 2 |a SpringerLink (Online service) 
041 0 7 |a eng  |2 ISO 639-2 
989 |b SBA  |a Springer Book Archives -2004 
856 |u http://dx.doi.org/10.1007/978-1-4302-1573-8?nosfx=y  |x Verlag  |3 Volltext 
082 0 |a 005.1 
520 |a 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