|
Beginning SQL Server 2000 for Visual Basic Developers - Reprint
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 MS Access can provide. SQL 2000, is tightly integrated with Windows 2000, offering
more support for XML and much improved OLAP (Online Analytical Processing) services.
This book is for VB developers who want to integrate SQL Server 2000 into their applications. It covers everything needed to work with SQL Server 2000, including topics such as SQL Server 2000 tools, managing database security, building and deploying English query applications, and more.
CONTENTS
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
|
