Microsoft SQL Server 2000 Programming by Example.pdf

Microsoft SQL Server 2000 Programming by Example

transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise,

without written permission from the publisher. No patent liability is assumed with respect to

the use of the information contained herein. Although every precaution has been taken in the

preparation of this book, the publisher and author assume no responsibility for errors or

omissions. Nor is any liability assumed for damages resulting from the use of the information

contained herein.

Library of Congress Catalog Card Number: 00-111702

Printed in the United States of America

First Printing: April, 2001

04 03 02 01 4 3 2 1

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have been

appropriately capitalized. Que Corporation 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.

Microsoft is a registered trademark of Microsoft Corporation.

SQL Server is a trademark of Microsoft Corporation.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but

no warranty or fitness is implied. The information provided is on an "as is" basis. The authors

and the publisher shall have neither liability nor responsibility to any person or entity with

respect to any loss or damages arising from the information contained in this book or from the

use of the CD or programs accompanying it.

Credits

Acquisitions Editor

Michelle Newcomb

Development Editor

Sean Dixon

Managing Editor

Thomas Hayes

Project Editor

Tonya Simpson

Copy Editor

Kay Hoskin

Indexer

Kelly Castell

Proofreader

Maribeth Echard

Technical Editor

Vincent Mayfield

Team Coordinator

Cindy Teeters

Media Developer

Michael Hunter

Interior Designer

Karen Ruggles

Cover Designer

Duane Rader

Page Layout

Brad Lenser

Liz Patterson

Dedication

This book is dedicated to Carlos and Yumaira, who taught me the key

elements for success in life: discipline and persistence.

— Carlos Eduardo Rojas

To Manuela, for being my wife, my confidant, my shelter, my partner, warmth

for my winters, and refreshing breeze for my summers.

— Fernando Guerrero

iii

About the Authors

Carlos Eduardo Rojas is a program manager with Planeta Networks, an Internet company headquartered in

Coral Gables, Florida that provides broadband applications to Internet service providers in Ibero-America. He

specializes in the design of n-tier applications, database implementation, and administration of SQL Server

databases. Prior to this role, he was a consultant and trainer with Manapro in Caracas, Venezuela, where he

is originally from. Also, he has participated as a speaker in various TechNet conferences in Venezuela.

Carlos earned a B.S. degree in Computer Science from University Simón Bolívar, Caracas, Venezuela. He is

a Microsoft Certified Systems Engineer + Internet (MCSE+I), Microsoft Certified Database Administrator

(MCDBA), Microsoft Certified Sales Specialist (MCSS), and has been awarded with the MVP (Most Valuable

Professional) status on SQL Server. He is also a voting member and volunteer of PASS, the professional

association for SQL Server.

Carlos can be reached at carlos@sqlserverbyexample.com .

Fernando G. Guerrero is a principal technologist and SQL Server product consultant in QA, United Kingdom.

His main role involves IT training, course development, and internal mentoring.

He writes for SQL Server Magazine ( http://www.sqlmag.com ), presented a session on SQL Server 2000

at TechEd 2000 Europe, and has accepted to speak at PASS2001, TechEd Europe 2001, VBUG 2001, VBITS

2001, VSLive, and SQL2THEMAX conferences during the year 2001.

He is a Civil and Hydrologic Engineer with almost 20 years'experience in software development and design, in

many cases applied to engineering environments.

He holds seven Microsoft Professional Certifications, including MCSE+Internet, MCSD, MCDBA, MCT, and

has been awarded with the MVP (Most Valuable Professional) status on SQL Server. He is also a voting

member and volunteer of PASS, the professional association for SQL Server.

His professional experience covers six years (1981–1987) as a lecturer in the Valencia's Polytechnic

University (Spain, http://www.upv.es ), where he was lecturing on surveying, photogrammetry, technical

drawing, and applied numerical methods in the Civil Engineering School and the Agricultural Engineering

School.

He built his own software company in Spain, TOU S.A., focused on desktop publishing and graphical tools for

the professional market, and was technical director in that company for four years (1987–1991).

Before joining QA (Nov. 1998), he spent eight years (1991–1998) as an international consultant for a

prestigious Spanish engineering firm ( http://www.inypsa.es ) , living in different countries, designing,

developing, and implementing information systems for projects financed by the World Bank, the European

Union, and the European Investment Bank.

Fernando can be reached at fernan@sqlserverbyexample.com .

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: