Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL .NET, Third Edition

Dejan Šunderić

McGraw-Hill

The McGraw-Hill Companies

The McGraw-Hill Companies
160 Spear Street, Suite 700
San Francisco, California 94105
U.S.A.

To arrange bulk purchase discounts for sales promotions, premiums, or fund-raisers, please contact McGraw-Hill at the above address.

© 2006 The McGraw-Hill Companies

All rights reserved. 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 DOC DOC 019876

0-07-226228-1

Acquisitions Editor: Wendy Rinaldi
Project Editor: Mark Karmendy
Acquisitions Coordinator: Alex McDonald
Technical Editor: Karl Hilsmann
Copy Editor: Mark Karmendy
Proofreader: Paul Tyler
Indexer: Claire Splan
Composition: International Typesetting and Composition
Illustration: International Typesetting and Composition
Series Design: Peter F. Hancik, Lucie Ericksen, Elizabeth Jang
Cover Series Design: Pattie Lee

This book was composed with Adobe® InDesign®.

Information has been obtained by McGraw-Hill from sources believed to be reliable. However, because of the possibility of human or mechanical error by our sources, McGraw-Hill, or others, McGraw-Hill 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.

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 wife Mirjana and my son Nikola for their patience, understanding, support, and inspiration.

About the Author

Dejan Šunderić, MCDBA, is the principal consultant at Trigon Blue, Inc. (http://www.trigonblue.com), and the president of the Toronto SQL Server User Group (http://www.tssug.ca). He specializes in database and application development on the SQL Server platform.

Projects that he has been involved with cover B2C and B2B e-commerce, financial, medical, 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 (http://www.trigonblue.com/stored_procedure.htm), and co-author of Windows 2000 Performance Tuning and Optimization and four other books, as well as numerous technical articles for several computer and professional publications.

His career started in Belgrade, Yugoslavia, where he graduated from the Faculty of Electrical Engineering. In 1995 he moved to Toronto, Canada, then in 2001 to Pittsburgh, PA. He is now back in Toronto working on a multi-terabyte database and leading a local organization of SQL Server professionals.

Dejan can be contacted via the book's web site (http://www.trigonblue.com/clr_stored_procedure).

Acknowledgments

I wish to thank all the people who helped to make this book a reality, and in particular:

• Olga Baranova, who created several examples for Chapters 11, 12, 13, 14, 18, and 21.

• Tom Woodhead, for straightening the winding course of my writings.