Instant SQL Server 2000 Applications [Illustrated] [Paperback]

Greg Buczek (Author)

Book Description

Series: Instant (Osborne) | Publication Date: May 8, 2001

Improve functionality and develop robust SQL Server applications with confidence using this collection of pre-written solutions.

Editorial Reviews

From the Back Cover

The Ultimate Collection of Ready-to-Use Code and Expert Techniques

Build robust SQL Server 2000 database applications easily using the pre-built projects packed into this essential resource. Inside, you'll find step-by-step details for creating several practical tools that use SQL Server 2000 as the back-end. Every application, script, and code snippet is contained on the CD and is cross-referenced and explained in the text, making it easier to find exactly what you're looking for. Save yourself hundreds of programming hours with this invaluable toolkit.

With this book, you'll learn to create the following:

• Money Manager
• Personal Information Manager (PIM)
• Help Desk
• Network Management Tool
• Code Library
• Customer Tracking Application
• Event Manager
• Collection Manager
• Online Store
• E-books

Coverage includes:

• Triggers
• Stored Procedures
• Visual Basic.NET
• Active Server Pages (ASP)
• Access
• T-SQL
• SQL Server 2000 security features

On the value-packed CD-ROM:

• All of the book's source code
• Practical sample applications

About the Author

Greg Buczek (Albuquerque, NM) is a Microsoft Certified Solutions Developer and a Microsoft Certified Trainer working as an independent Consultant. He is the Webmaster of over 15 Web sites where he strives to bring dynamic, data-driven content to the Internet.

Product Details

• Paperback: 784 pages
• Publisher: McGraw-Hill Companies (May 8, 2001)
• Language: English
• ISBN-10: 0072133201
• ISBN-13: 978-0072133202
• Product Dimensions: 9.1 x 7.5 x 2.3 inches
• Shipping Weight: 4.6 pounds
• Average Customer Review: 3.8 out of 5 stars  See all reviews (5 customer reviews)
• Amazon Best Sellers Rank: #3,322,468 in Books (See Top 100 in Books)

More About the Author

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

Customer Reviews

Most Helpful Customer Reviews

7 of 8 people found the following review helpful:

2.0 out of 5 stars Good - but Not all Code Works, January 28, 2002

By 

R. Caron "SightSeer" (Montreal, QC CANADA) - See all my reviews
(REAL NAME)   

This review is from: Instant SQL Server 2000 Applications (Paperback)

I purchased this book more for the quick and dirty SQL applications than for the detailed 'How-To'. Unfortunately some code examples were created with a very early version of Visual Studio.NET. The code is now obsolete, so you must spend a fair amount of time repairing the code and bringing it up to the latest VisualStudio.NET conventions. Even then you might not get it working. I wish the publisher would make code corrections and errata available on their web site, but they do not.

4 of 4 people found the following review helpful:

5.0 out of 5 stars A great reference book for developing SQL applications, September 20, 2001

By A Customer

This review is from: Instant SQL Server 2000 Applications (Paperback)

The strength of this book is that is teaches through examples, and for someone like myself who knows a little about SQL and needs concrete examples to solidify understanding, this is an excellent resource. Mr. Buczek does an excellent job of breaking down the code in his examples and explaining what each line does. The book also has a good introduction through the first several chapters that help you get your feet wet if you have done little with SQL Server before.

6 of 7 people found the following review helpful:

5.0 out of 5 stars Instant SQL Server 2000 Apps Review, June 12, 2001

By 

Ted Wood (Albuquerque, NM) - See all my reviews

This review is from: Instant SQL Server 2000 Applications (Paperback)

I now posess five (5) of Mr. Buczek's books. In this book, as in all the rest, it remains evident that Greg has a genuine concern that the reader learn from his printed material and urges further learning by manipulating solutions that he has presented.

Chapter 1 does a great job of reviewing the basics of working with SQL Server and the SQL Server Enterprise Manager. As a programmer, I have designed an application using VB as the front end to SQL Server. Chapter 3 provided invaluable information.

I found the Solutions provided by Mr. Buczek as real-world, and code examples were easily transposed to meet my programming needs.

The Visual Basic Quick Reference in Appendix A and the T-SQL Language Reference in Appendix B are more than worth the price of this book. I will be eagerly waiting for the next release from Mr. Buczek.