Susan Sales Harkins, Martin Reid

SQL (eBook, PDF)

Access to SQL Server

• Format: PDF

Produktbeschreibung

This book is peppered with advice and tips from industry experts on everything from basic SQL right up to an introduction on executing Stored Procedures via the Web. The authors see SQL - as it is used in Access, MSDE and SQL Server, as being the common thread.

---

Dieser Download kann aus rechtlichen Gründen nur mit Rechnungsadresse in A, B, BG, CY, CZ, D, DK, EW, E, FIN, F, GR, HR, H, IRL, I, LT, L, LR, M, NL, PL, P, R, S, SLO, SK ausgeliefert werden.

Produktdetails

• Verlag: Apress
• Seitenzahl: 698
• Erscheinungstermin: 25. Juni 2008
• Englisch
• ISBN-13: 9781430215738
• Artikelnr.: 44000878

Autorenporträt

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.

Inhaltsangabe

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