SQL Server 2000 Stored Procedure & XML P - Sunderic_ Dejan.pdf

(14294 KB) Pobierz
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
878383267.029.png
SQL Server TM 2000
Stored Procedure
& XML Programming
Second Edition
Dejan Šunderic
McGraw-Hill /Osborne
New York Chicago San Francisco
Lisbon London Madrid Mexico City Milan
New Delhi San Juan Seoul Singapore Sydney Toronto
878383267.030.png 878383267.031.png 878383267.032.png 878383267.001.png 878383267.002.png 878383267.003.png 878383267.004.png
McGraw-Hill /Osborne
2100 Powell Street, 10 th Floor
Emeryville, California 94608
U.S.A.
To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact
McGraw-Hill/Osborne at the above address. For information on translations or book distributors
outside the U.S.A., please see the International Contact Information page immediately following the
index of this book.
SQL Server 2000 Stored Procedure & XML Programming, Second Edition
Copyright © 2003 by The McGraw-Hill Companies. All rights reserved. Printed in the United States
of America. Except as permitted under the Copyright Act of 1976, no part of this publication may be
reproduced or distributed in any form or by any means, or stored in a database or retrieval system,
without the prior written permission of publisher, with the exception that the program listings may be
entered, stored, and executed in a computer system, but they may not be reproduced for publication.
1234567890 CUS CUS 019876543
ISBN 0-07-222896-2
Publisher
Brandon A. Nordin
Vice President & Associate Publisher
Scott Rogers
Acquisitions Editor
Lisa McClain
Project Editor
Janet Walden
Acquisitions Coordinator
Athena Honore
Technical Editor
Deborah Bechtold
Development Editor
Tom Woodhead
Copy Editor
William McManus
Proofreader
Laurie Stewart
Indexer
Valerie Robbins
Computer Designers
Carie Abrew, Tara A. Davis, Lucie Ericksen
Illustrators
Lyssa Wald, Melinda Moore Lytle, Kathleen Fay Edwards
Series Designer
Peter F. Hancik
Cover Series Designer
Pattie Lee
This book was composed with Corel VENTURA™ Publisher.
Information has been obtained by McGraw-Hill/Osborne from sources believed to be reliable. However, because of the possibility
of human or mechanical error by our sources, McGraw-Hill/Osborne, or others, McGraw-Hill/Osborne does not guarantee the
accuracy, adequacy, or completeness of any information and is not responsible for any errors or omissions or the results obtained
from the use of such information.
878383267.005.png 878383267.006.png 878383267.007.png
 
878383267.008.png 878383267.009.png 878383267.010.png 878383267.011.png 878383267.012.png 878383267.013.png 878383267.014.png 878383267.015.png 878383267.016.png 878383267.017.png
Writing a book isn’t easy, but living with someone
who is writing a book can be, at times, even harder.
I would like to thank my family for their patience,
understanding, and inspiration.
Acknowledgments
I wish to thank all the people who helped to make this book a reality,
in particular:
Tom Woodhead, for straightening the winding course of my writings.
Olga Baranova, who created several examples for Chapters 10, 11, and 15.
Wendy Rinaldi and Lisa McClain, for the opportunity to do this project.
Athena Honore and Janet Walden, for their patience, expertise, and
hard work.
Deborah Bechtold, for her expertise and hard work beyond the call of duty.
878383267.018.png 878383267.019.png 878383267.020.png 878383267.021.png 878383267.022.png
About the Author
Dejan Šunderic is the principal consultant at Trigon Blue, Inc. (www.trigonblue.com).
He specializes in database and application development for Internet and
Windows platforms.
Projects that he has been involved with cover B2C and B2B e-commerce, financial,
document-management, mortgage, asset management, insurance, real-estate, IT
supply chain, process control, communication, data warehouse, and OLAP systems.
Dejan has worked as a database architect, database and application developer, database
administrator, team leader, project manager, writer, and technical trainer.
He is the author of SQL Server 2000 Stored Procedure Programming (www
.trigonblue.com/stored_procedure.htm), coauthor of Windows 2000 Performance
Tuning and Optimization, and three other books, as well as numerous technical
articles for several computer and professional publications.
His career started in Belgrade, Yugoslavia where he graduated on Faculty of
Electrical Engineering. In 1995 he moved to Toronto, Canada and he is currently
in Pittsburgh, U.S.A. He holds certifications for Microsoft Certified Solution
Developer (MCSD), Microsoft Certified Database Administrator (MCDBA), and
Certified SQL Server Programmer Master Level. Dejan is a member of Toronto
SQL Server User Group (www.tssug.com), Visual Basic Developer’s Online
Group (www.visualbyte.com/vbdogs), Pittsburgh SQL Server User Group
(www.pssug.com), and Professional Association for SQL Server (www.sqlpass.org).
Dejan can be contacted by email (dejan’s username on hotmail.com server; to
avoid spam filter, put sp_book in the subject) or the book’s web site (www
.trigonblue.com/sqlxml).
878383267.023.png 878383267.024.png 878383267.025.png 878383267.026.png 878383267.027.png 878383267.028.png
Zgłoś jeśli naruszono regulamin