Thearon Willis

Beginning SQL Server 2000 for Visual Basic Developers

Mitwirkender: Willis, Thearon

• Gebundenes Buch

Produktbeschreibung

* Full coverage of SQL Server tools, from installation Query Analyzer to English Query applications. * Shows how to integrate SQL Server into your VB applications using ADO. * Extensive coverage of Transact-SQL, and particularly building stored procedures and calling them from VB code. * Coverage extends right down to advanced topics like SQL Server XML and building web reports.

---

This is the only book that provides comprehensive coverage of SQL Server 2000 specifically from a Visual Basic programmer's point of view. SQL Server is now the first choice for the Visual Basic developer who wants a more powerful, reliable, and sophisticated database than Microsoft Access can provide. SQL Server 2000 is tightly integrated with Windows 2000, offering more support for XML and much improved Online Analytical Processing (OLAP) services.

This book is for Visual Basic developers who want to integrate SQL Server 2000 into their applications. It covers everything you need to know to work with SQL Server 2000 and provide users of your Visual Basic and web-based applications with controlled access to your data. You'll start with an introduction to designing and creating a database and then move on to create increasingly complex T-SQL stored procedures. Throughout, you'll learn how to incorporate data access (including ADO) into your Visual Basic applications, manage security, and make data available across the Web.

---

Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.

Produktdetails

• Verlag: Apress / Wrox Press
• Softcover reprint of the original 1st ed.
• Seitenzahl: 880
• Erscheinungstermin: 2. September 2003
• Englisch
• Abmessung: 235mm x 191mm x 47mm
• Gewicht: 1615g
• ISBN-13: 9781590592731
• ISBN-10: 1590592735
• Artikelnr.: 09471065

Autorenporträt

Thearon Willis is a senior consultant with 19 years of IT experience. He is a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Inhaltsangabe

Introduction to SQL Server 2000; Installing the Personal Edition of SQL Server 2000; Designing and Creating the Development Database; SQL Server Security; SQL Server Query Analyzer; Database Connections; Introduction to Stored Procedures; Stored Procedures versus SQL Statements; Selecting Data; Inserting Data; Updating Data; Deleting Data; Working with Text Data; Installing Internet Information Server (IIS); SQL Server and XML; XML Web Reports; Case Study Part 1: Building an English Query Application; Case Study Part 2: Deploying an English Query Application; Appendix A: SQL Server and VB Data Types; Appendix B: ADO 2.6 Object Model; Appendix C: SQL Server Functions; Appendix D: Building the Hardware Tracking Framework; Appendix E: Creating the Hardware Tracking Business Server Component; Appendix F: References.