rent-now

Rent More, Save More! Use code: ECRENTAL

5% off 1 book, 7% off 2 books, 10% off 3+ books

9781590592731

Beginning SQL Server 2000 for Vb Developers

by
  • ISBN13:

    9781590592731

  • ISBN10:

    1590592735

  • Format: Paperback
  • Copyright: 2000-11-01
  • Publisher: Springer-Verlag New York Inc
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
  • Write a Review Icon Write a Review
List Price: $39.99 Save up to $25.59
  • Buy New
    $39.95
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-3 BUSINESS DAYS

Summary

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 wanting 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 VB 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

Introductionp. 1
Introduction to SQL Server 2000p. 11
Installing the Personal Edition of SQL Server 2000p. 31
Designing and Creating the Development Databasep. 65
SQL Server Securityp. 101
SQL Server Query Analyzerp. 127
Database Connectionsp. 167
Introduction to Stored Proceduresp. 201
Stored Procedures versus SQL Statementsp. 253
Selecting Datap. 295
Inserting Datap. 353
Updating Datap. 403
Deleting Datap. 451
Working with Text Datap. 485
Installing Internet Information Server (IIS)p. 539
SQL Server and XMLp. 563
XML Web Reportsp. 605
Building an English Query Applicationp. 663
Deploying an English Query Applicationp. 713
SQL Server and VB Data Typesp. 751
ADO 2.6 Object Modelp. 755
SQL Server Functionsp. 771
Building the Hardware Tracking Frameworkp. 803
Creating the Hardware Tracking Business Server Componentp. 819
App. F: Referencesp. 831
Support, Errata, and forums.apress.comp. 835
Indexp. 845
Table of Contents provided by Blackwell. All Rights Reserved.

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program