Ships from: Berlin, Germany
Usually ships in 1-2 business days
Ships from: Berlin, Germany
Usually ships in 1-2 business days
Ships from: Chatham, NJ
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
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.
| Introduction | 1 | |
| Ch. 1 | Introduction to SQL Server 2000 | 11 |
| Ch. 2 | Installing the Personal Edition of SQL Server 2000 | 31 |
| Ch. 3 | Designing and Creating the Development Database | 65 |
| Ch. 4 | SQL Server Security | 101 |
| Ch. 5 | SQL Server Query Analyzer | 127 |
| Ch. 6 | Database Connections | 167 |
| Ch. 7 | Introduction to Stored Procedures | 201 |
| Ch. 8 | Stored Procedures versus SQL Statements | 253 |
| Ch. 9 | Selecting Data | 295 |
| Ch. 10 | Inserting Data | 353 |
| Ch. 11 | Updating Data | 403 |
| Ch. 12 | Deleting Data | 451 |
| Ch. 13 | Working with Text Data | 485 |
| Ch. 14 | Installing Internet Information Server (IIS) | 539 |
| Ch. 15 | SQL Server and XML | 563 |
| Ch. 16 | XML Web Reports | 605 |
| Case Study Pt. 1 | Building an English Query Application | 663 |
| Case Study Pt. 2 | Deploying an English Query Application | 713 |
| App. A | SQL Server and VB Data Types | 751 |
| App. B | ADO 2.6 Object Model | 755 |
| App. C | SQL Server Functions | 771 |
| App. D | Building the Hardware Tracking Framework | 803 |
| App. E | Creating the Hardware Tracking Business Server Component | 819 |
| App. F: References | 831 | |
| App. G | Support, Errata, and forums.apress.com | 835 |
| Index | 845 |
Overview
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 ...