Beginning SQL Server 2000 for Vb Developers - Brossura

Willis, Thearon

Brossura

ISBN 10: 1590592735 ISBN 13: 9781590592731

Casa editrice: Apress, 2003

Riassunto

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 wanting 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 VB 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.

Su questo libro

L'autore

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.

Contenuti

Chapter 1--Introduction to SQL Server 2000
Chapter 2--Installing the Personal Edition of SQL Server 2000
Chapter 3--Designing and Creating the Development Database
Chapter 4--SQL Server Security
Chapter 5--SQL Server Query Analyzer
Chapter 6--Database Connections
Chapter 7--Introduction to Stored Procedures
Chapter 8--Stored Procedures versus SQL Statements
Chapter 9--Selecting Data
Chapter 10--Inserting Data
Chapter 11--Updating Data
Chapter 12--Deleting Data
Chapter 13--Working with Text Data
Chapter 14--Installing Internet Information Server (IIS)
Chapter 15--SQL Server and XML
Chapter 16--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

Dettagli dell?edizione

• Editore: Apress
• Data di pubblicazione: 2003
• ISBN 10: 1590592735
• ISBN 13: 9781590592731
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 861