Special Edition Using Microsoft SQL Server 6.5

Welcome to Que's electronic book, Special Edition, Using Microsoft SQL Server 6.5. It is designed to make reading and searching the text easy.

Every effort has been made to keep the electronic version consistent with the printed version; however, if there is a conflict the printed version should be considered correct.

Acknowledgments

I'd like to thank my family for their patience and understanding in providing the quality time necessary to complete the book. I'd especially like to thank my wife Cathy, who read and offered suggestions on my first, second, and sometimes third drafts of chapters. I'd like apologize to my son Jeffrey for not working out some way to include his picture in this book (as I did in QUE's Using Windows NT .

I'd like to thank Dick Vigilante and Howard Decklebaum of the Information Technologies Institute of New York University for the opportunity to teach courses on related computer topics the past 15 years. I'd also like to thank the students of those classes who, although they were attending evening classes and were tired from long work days, still managed to ask questions that helped me to learn along with them.

Thanks to the people at the various training organizations at which I've delivered training including: Mike, Jim, and Andy of Online Consulting in Wilmington, Delaware; Karen, Kenan, and Carmen at Dow Jones Training Services in Princeton, New Jersey; Bruce at Teltech and Ronnie at Creative Data Movers in New York City; and Jim at Professional Training Services in Nashua, New Hampshire.

I'd also like to thank Jim Walker and Howard Nusbaum. Jim, a former colleague at Digital Equipment Corporation, has provided me with opinions, often different than mine, which led me to re-examine my ideas. Howard has provided the questions of a novice user which have kept me attuned to the need for understanding the a complete range of users rather than just those who are technically savvy.

—Bob Branchek

I would like to thank my family, especially my father, for inspiration and guidance. I also would like to thank all my friends at Phoenix who are great to work with and who provide an excellent place to play with new toys like Java and the Internet. Finally, I'd like to thank my adopted U.S. family (they know who they are) for all their help, support, and friendship in the time that I've been lucky enough to know them. And final, final thanks to all the folks at Que, especially Deborah Abshier, Jeff Riley and Al Valvano for "learning me to read" and for bringing me into the world of publishing."

—Peter Hazlehurst

First, thank you to the team at Que, specifically Al Valvano and Jeff Riley for their persistence in making this book become a reality and working through the changing landscape with SQL Server to make this book the best it can be. Many thanks to my family for putting up with the continuous push on schedules and "just one more section." Without their help and support, this would not have been possible. A special thank you to my wife for her adding a much-needed round of editing on materials—it was very much appreciated. Also, many thanks to Mike B. for all of the foresight, commitment, and pushing to the edge of technologies. Without his passion for technology, life would not be what it is today.

—Stephen Wynkoop

About the Authors

Bob Branchek is an independent lecturer, writer, and the president of Bob Branchek Associates, Inc., a New Jersey-based Microsoft Solution Provider specializing in the delivery of customized training and consulting for Microsoft Windows NT and SQL Server. Bob has 19 years of experience in the computer industry and contributed to Que's Using Windows NT. Bob also lectures at the Information Technologies Institute of New York University in New York City and currently is teaching a course on client/server computing. He's the writer and on-camera talent for several video training courses, and is a Microsoft Certified Professional. He possesses both B.S. and M.A. degrees. While employed for Digital Equipment Corporation's Educational Training Services, he was awarded its Instructor Excellence Award in 1982, 1983 and 1984. Bob can be reached on the Internet at 73227.1627@compuserve.com or on CompuServe at 73227,1627.

Peter Hazlehurst, born in Oxford, England, and educated in Australia, has spent the past five years in the client/server development industry specializing in real-world business solutions. Peter moved to the U.S. three years ago to join Phoenix International as its first employee and currently is Senior Systems Architect. Phoenix is the leading client/server vendor of Banking Software and its product is installed in 13 institutions in the U.S. and six internationally. The relational database Phoenix selected is Sybase System 10, written entirely in Gupta's SQLWindows. Phoenix currently is in the process of porting to Microsoft SQL Server to target smaller domestic banks with the concept of the "bank in a box." Phoenix has shown that client/server works for real businesses. Peter can be reached via e-mail on the Internet at phazlehurst@phoenixint.com or on CompuServe at 73114,3145.

Stephen Wynkoop is an author and lecturer working almost exclusively with Microsoft-based technologies. Stephen has been a regular speaker at Microsoft's TechEd conferences and has written two other books on Access and Office '95 development technologies. He contributed to Que's Special Edition Using Windows NT Server and is working on other Que regarding exciting technologies on the horizon. Stephen can be reached on the Internet at swynk@primenet.com.

Scott L. Warner is a programmer/analyst for Service Graphics, Inc. in Indianapolis. He received his degree from Purdue University's computer technology department. In addition to Delphi, Scott also develops applications in PowerBuilder and Visual Basic. He can be reached on the Internet atswarner@iquest.net.

Electronic Book Information

Please send all suggestions and comments about this E-book to medined@planet.net. We are continually looking for better ways to present informational material. If you are aware of any new book reading technology that you believe is or will become a standard in the future, please let us know.

Thanks,
David Medinets

We'd Like To Hear From You!

As part of our continuing effort to produce books of the highest possible quality, Que would like to hear your comments. To stay competitive, we really want you, as a computer book reader and user, to let us know what you like or dislike most about Special Edition Using Microsoft SQL Server 6.5 or other Que products.

You can mail comments, ideas, or suggestions to the address below, or send us a fax at (317) 581-4663. For the on-line inclined, Macmillan Computer Publishing has a forum on CompuServe (type GO QUEBOOKS at any prompt) through which our staff and authors are available for questions and comments. The address of our Internet site is http://www.mcp.com (World Wide Web).

In addition to exploring our forum, please feel free to contact me personally on CompuServe at 74671,3710 to discuss your opinions of this book. You can also reach me on the Internet at avalvano@que.mcp.com.

Thanks in advance—your comments will help us to continue publishing the best books available on computer topics in today's market.

Al Valvano
Acquisitions Editor
Que Corporation
201 W. 103rd Street
Indianapolis, Indiana 46290
USA

Copyright Information

Copyright^© 1996 by Que^(r) Corporation.

All rights reserved. Printed in the United States of America. No part of this book may be used or reproduced in any form or by any means, or stored in a database or retrieval system, without prior written permission of the publisher except in the case of brief quotations embodied in critical articles and reviews. Making copies of any part of this book for any purpose other than your own personal use is a violation of United States copyright laws. For information, address Que Corporation, 201 W. 103rd Street, Indianapolis, IN 46290. You may reach Que's direct sales line by calling 1-800-428-5331.

Library of Congress Catalog No.: 95-71424

ISBN: 0-7897-0097-2

This book is sold as is, without warranty of any kind, either express or implied, respecting the contents of this book, including but not limited to implied warranties for the book's quality, performance, merchantability, or fitness for any particular purpose. Neither Que Corporation nor its dealers or distributors shall be liable to the purchaser or any other person or entity with respect to any liability, loss, or damage caused or alleged to be caused directly or indirectly by this book.

98 97 96 4 3 2 1

Interpretation of the printing code: the rightmost double-digit number is the year of the book's printing; the rightmost single-digit number, the number of the book's printing. For example, a printing code of 96-1 shows that the first printing of the book occurred in 1996.

All terms mentioned in this book that are known to be trademarks or service marks have been appropriately capitalized. Que cannot attest to the accuracy of this information. Use of a term in this book should not be regarded as affecting the validity of any trademark or service mark.

Screen reproductions in this book were created using Collage Plus from Inner Media, Inc., Hollis, NH.

Credits

Table of Contents

Introduction