Beginning SQL Server 2000 for Visual Basic Developers

✍ Scribed by Thearon Willis (auth.)

• Publisher: Apress
• Year: 2003
• Tongue: English
• Leaves: 826
• Edition: 1
• Category: Library

✦ Synopsis

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 who wants 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 Visual Basic 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.

✦ Table of Contents

Front Matter....Pages N2-ix
Introduction....Pages 1-8
Introduction to SQL Server 2000....Pages 11-28
Installing the Personal Edition of SQL Server 2000....Pages 31-62
Designing and Creating the Development Database....Pages 65-99
SQL Server Security....Pages 101-124
SQL Server Query Analyzer....Pages 127-164
Database Connections....Pages 167-198
Introduction to Stored Procedures....Pages 201-250
Stored Procedures versus SQL Statements....Pages 253-292
Selecting Data....Pages 295-351
Inserting Data....Pages 353-400
Updating Data....Pages 403-448
Deleting Data....Pages 451-482
Working with Text Data....Pages 485-536
Installing Internet Information Server (IIS)....Pages 539-560
SQL Server and XML....Pages 563-603
XML Web Reports....Pages 605-661
Case Study Part 1 Building an English Query Application....Pages 663-710
Case Study Part 2 Deploying an English Query Application....Pages 713-748
Back Matter....Pages 751-861

✦ Subjects

Software Engineering/Programming and Operating Systems