Beginning SQL Server 2000 for Visual Basic Developers [Paperback]

Thearon Willis (Author)

Book Description

Series: Programmer to Programmer | Publication Date: January 15, 2000

SQL Server is now first choice for the Visual Basic developer wanting a more powerful, reliable and sophisticated database than MS Access can provide. Microsoft is actively encouraging a growing number of users onto the SQL platform, by making it cheaply available. The new release, SQL 2000, is tightly integrated with Windows 2000, offering more support for XML and much improved OLAP (Online Analytical Processing) services.

Editorial Reviews

From the Publisher

This book is aimed at intermediate and advanced Visual Basic developers who already have some experience working with some other type of relational database including Microsoft Access. Experience with Microsoft ActiveX Data Objects is also assumed but not required.

About the Author

Thearon Willis is a senior consultant with 19 years of IT experience. He is currently a consultant for an International Insurance company, which provides Web programming services. His Web development tools of choice are ASP, Dynamic HTML, Visual Basic and SQL Server. Thearon has worked with Wrox Press previously on Beginning VB SQL Server 7.

Product Details

• Paperback: 861 pages
• Publisher: Apress (January 15, 2000)
• Language: English
• ISBN-10: 1861004672
• ISBN-13: 978-1861004673
• Product Dimensions: 9.3 x 7.5 x 1.9 inches
• Shipping Weight: 3.2 pounds
• Average Customer Review: 4.8 out of 5 stars  See all reviews (14 customer reviews)
• Amazon Best Sellers Rank: #2,173,597 in Books (See Top 100 in Books)
  • #84 in Books > Computers & Technology > Databases > Beginning & Introductory

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

11 of 11 people found the following review helpful:

5.0 out of 5 stars This book is great, July 30, 2001

By A Customer

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

After working on mainframe applications for the last 17 years, I was put into a new group and expected to write an application in VB and SQL Server. I was completely lost! With this book, I felt like the author was sitting next to me answering all the questions I had about how to make my stuff work. In just a week, I went from knowing virtually nothing to being able to finish the first part of the project I'm working on. The other books I had looked at either were too advanced (come on - I've been working in '70's technology!) or were for beginning programmers. It was well-written, easy to follow, and answered all my questions. I would recommend this book for programmers new to SQL Server.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Information Promise - Information delivered, April 12, 2002

By 

Active Trader "prchrist3" (Kaysville, UT United States) - See all my reviews

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

I have just finished Thearon Willis's book and I feel that my money was well spent. I am a Visual Basic programmer that has been working with Oracle for the last 5 years and I felt the need to get up to speed with SQL Server 2000. Per the title of the book I am a BEGINNER with SQL Server and this book met my needs exactly.

I actually read the book and manually coded all the examples to build the test projects. Kudos to Mr. Willis for actually testing the code that he put in the book. All examples except one (for the stored procedure for temporary tables, you have to add SET NOCOUNT ON to the script), worked as they were supposed to.

The book went into great detail on the logic and function of code used. Every line of code was explained clearly and concisely. I believe the section on XML was superb. I have struggled through a couple of short courses on XML and was left confused and discouraged. This book helped all the pieces fall into place and gave me the confidence and knowledge to actually create XML projects for the real world.

Sample code is available for download from Wrox and they do respond to requests for help (the SET NOCOUNT ON issue) in a few days.

7 of 7 people found the following review helpful:

5.0 out of 5 stars Perfect for beginners, December 19, 2000

By 

Jerry D Sevier Jr (Tucson, Arizona) - See all my reviews

This review is from: Beginning SQL Server 2000 for Visual Basic Developers (Paperback)

I had never touched SQL Server, nor was my programming up to par. However, Thearon Willis' style is easy to follow and fills in the learning curve nicely. After reading this book, I had a strong foundation needed to tackle most of the database requirments of my company.