Beginning Visual Basic SQL Server 7

Thearon Willis

800 pages, parution le 15/01/2000

Ajouter à une liste

Indisponible

Résumé

Most Visual Basic applications involve database programming of some kind, and SQL Server 7.0 is the database of choice for many Visual Basic programmers. This book introduces SQL Server 7.0, covering all its essential features, and then moves on to discuss building VB applications using a SQL Server backend database.

After stepping through installation of the Desktop edition of SQL Server, you'll learn about its tools, in particular the Enterprise Manager and Query Analyzer, as we create, populate, and modify an example database. You'll see how to set up security on your database and you'll also learn how to write, debug, and execute increasingly complex stored procedures to manipulate the data. Data access from VB applications using ADO is also covered, and you'll see how to prepare your application for the production environment.

Hands on examples are a key part of the book; in each chapter you will work towards building a complete and comprehensive application. The book concludes with three extensive case studies that bring together all the knowledge that you've acquired.

Who is this book for?

This book is aimed at Visual Basic developers who wish to start using SQL Server 7.0 in their applications. No knowledge of SQL Server is required, although basic familiarity with a relational database such as Access is useful.

What does this Book Cover?

Basics of relational database design
Installation of SQL Server 7.0 Desktop edition
Creating and modifying a database in SQL Server
Defining primary and foreign key relationships, and indexes
Setting up security on the database
Using T-SQL to write stored procedures
Calling stored procedures from VB and business server components
Writing English Query applications

Table of contents

Introduction
Chapter 1: Introduction to SQL Server
Chapter 2: Installing the Desktop Edition of SQL Server
Chapter 3: 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 vs T-SQL Statements
Chapter 9: Selecting Data
Chapter 10: Inserting Data
Chapter 11: Updating Data
Chapter 12: Deleting Data
Chapter 13: Creating a Front-End Program
Chapter 14: Creating a Business Server Component
Chapter 15: Working With Text Data
Chapter 16: Preparing for the Test and Production Environments
Case Study 1 - Wrox Auto Works Customer Application
Case Study 2 - Wrox Auto Works Sales Staff Application
Case Study 3 - Customer English Query Application
Appendix A: T-SQL and VB Data Types
Appendix B: ADO 2.5 Object Model and Constants
Appendix C: SQL Server Functions
Appendix D: Support and Errata

L'auteur - Thearon Willis

Thearon Willis - Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an International Insurance company, which provides Web programming services. His Web development tools of choice are ASP, Dynamic HTML, Visual Basic and SQL Server.