SQL

Access to SQL Server

Susan Sales Harkins, Martin Reid (Autoren)

Buch | Softcover

698 Seiten

2002 | Softcover reprint of the original 1st ed.
Apress (Verlag)
978-1-893115-30-9 (ISBN)

Artikel merken

SQL: Access to SQL Server is more than just a comprehensive reference tool for Access developers. 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.

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.

Susan Sales Harkins is an independent consultant specializing in Microsoft Access, Office, and Visual Basic for Applications. For several years, Susan was editor-in-chief at The Cobb Group, publishing several computer-based monthly journals. She's the author of two books on Access: Using Microsoft Access 97 and Using Microsoft Access 2000. Currently, Susan writes for a number of publishers, including Element K Journals, PC Magazine, ZDNet, CNet, and TechRepublic.

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

Reihe/Serie	Books for Professionals by Professionals
Reihe/Serie	The Expert's Voice
Zusatzinfo	XIX, 698 p.
Verlagsort	Berkley
Sprache	englisch
Maße	191 x 235 mm
Themenwelt	Informatik ► Datenbanken ► SQL Server
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
	Mathematik / Informatik ► Informatik ► Software Entwicklung
Schlagworte	Access 2000; Programmierung • Access SQL • Database • Microsoft SQL Server 2000 • Relational Database • SQL Server • SQL (Structured Query Language)
ISBN-10	1-893115-30-5 / 1893115305
ISBN-13	978-1-893115-30-9 / 9781893115309
Zustand	Neuware