SQL

Access to SQL Server

Häftad, Engelska, 2002

507 kr

Beställningsvara. Skickas inom 3-6 vardagar. Fri frakt över 249 kr.

Beskrivning

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

Produktinformation

Utgivningsdatum:2002-01-29
Mått:191 x 235 x 38 mm
Vikt:1 327 g
Format:Häftad
Språk:Engelska
Antal sidor:698
Förlag:APress
ISBN:9781893115309

Utforska kategorier

Programmeringsböcker inom Data och IT

Mer om författaren

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.

Innehållsförteckning

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