Overview
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 storedprocedures
- Calling stored procedures from VB and business server components
- Writing English Query applications
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.
Synopsis
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.