SQL
Server 2000 is a feature-rich and robust
enterprise-level database application, which many
VB
programmers choose to, provide the
data layer in their
n-tier applications.
This book covers A you need to know to work with SQL
Server 2000, to provide users of your VB and web-based
applications with controlled access to your data.
creating increasingly complex T-SQL stored procedures,
you'll learn how to incorporate data access (including ADO)
into your VB applications, manage security, and make data
available across the Web.
Comprehensively explained step-by-step examples will
guide you through creating an entire VB-based application
to, manage both the data itself and access to that data.
Additionally, you will learn how to create and deploy web
reports and an English Query application.
Who is this book for?
This book is for VB developers who want to, integrate
SQL Server 2000 into their applications. No previous
knowledge of SQL Server is assumed.
What does this book cover? Introduction to relational
database design and theory Installing the Personal Edition
of SQL Server 2000 SQL Server 2000 tools T-SQL syntax for
queries and stored procedures How to create and run stored
procedures from VB applications and components
Managing database security
o XML features of SQL Server 2000
o Producing formatted XML web reports using XSL
o Building and deploying English Query applications
Summary of Contents
- Introduction
- 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 XIVIL
- Chapter 16: XIVIL 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
- Appendix G; Support, Errata, and P2P.wrox.com
- Index