Skip to main content
  • Book
  • © 2003

Beginning SQL Server 2000 for Visual Basic Developers

Apress

Authors:

  • Full coverage of SQL Server tools, from installation Query Analyzer to English Query applications

  • Shows how to integrate SQL Server into your VB applications using ADO

  • Extensive coverage of Transact-SQL, and particularly building stored procedures and calling them from VB code

  • Coverage extends right down to advanced topics like SQL Server XML and building web reports

Buy it now

Buying options

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

This is a preview of subscription content, log in via an institution to check for access.

Table of contents (19 chapters)

  1. Front Matter

    Pages N2-ix
  2. Introduction

    • Thearon Willis
    Pages 1-8
  3. Introduction to SQL Server 2000

    • Thearon Willis
    Pages 11-28
  4. SQL Server Security

    • Thearon Willis
    Pages 101-124
  5. SQL Server Query Analyzer

    • Thearon Willis
    Pages 127-164
  6. Database Connections

    • Thearon Willis
    Pages 167-198
  7. Introduction to Stored Procedures

    • Thearon Willis
    Pages 201-250
  8. Stored Procedures versus SQL Statements

    • Thearon Willis
    Pages 253-292
  9. Selecting Data

    • Thearon Willis
    Pages 295-351
  10. Inserting Data

    • Thearon Willis
    Pages 353-400
  11. Updating Data

    • Thearon Willis
    Pages 403-448
  12. Deleting Data

    • Thearon Willis
    Pages 451-482
  13. Working with Text Data

    • Thearon Willis
    Pages 485-536
  14. Installing Internet Information Server (IIS)

    • Thearon Willis
    Pages 539-560
  15. SQL Server and XML

    • Thearon Willis
    Pages 563-603
  16. XML Web Reports

    • Thearon Willis
    Pages 605-661

About this book

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.

About the author

Thearon Willis is a senior consultant with 19 years of IT experience. He is a consultant for an international insurance company that provides web programming services. His web development tools of choice are ASP, dynamic HTML, Visual Basic, and SQL Server.

Bibliographic Information

  • Book Title: Beginning SQL Server 2000 for Visual Basic Developers

  • Authors: Thearon Willis

  • DOI: https://doi.org/10.1007/978-1-4302-5131-6

  • Publisher: Apress Berkeley, CA

  • eBook Packages: Springer Book Archive

  • Copyright Information: Thearon Willis 2003

  • Softcover ISBN: 978-1-59059-273-1Published: 02 September 2003

  • eBook ISBN: 978-1-4302-5131-6Published: 11 November 2013

  • Edition Number: 1

  • Number of Pages: X, 880

  • Topics: Database Management, Software Engineering/Programming and Operating Systems

Buy it now

Buying options

eBook USD 29.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 39.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access