Microsoft SQL Server 2005 Stored Procedure Programming in T-SQL & .NET

Dejan Šunderić

McGraw-Hill

The McGraw-Hill Companies

The McGraw-Hill Companies160 Spear Street, Suite 700San Francisco, California 94105U.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

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.