SQL Server 2000 Stored Procedures Handbook


Tony Bain

Louis Davidson

Robin Dewson

Chuck Hawkins

Apress

Copyright 2003 Tony Bain, Louis Davidson, Robin Dewson, and Chuck Hawkins

All rights reserved. No part of this work may be reproduced or transmitted in any form or by any means, electronic or mechanical, including photocopying, recording, or by any information storage or retrieval system, without the prior written permission of the copyright owner and the publisher.

(pbk):

1-59059-287-5

2345678910

Trademarked names may appear in this book. Rather than use a trademark symbol with every occurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit of the trademark owner, with no intention of infringement of the trademark.

Distributed to the book trade in the United States by Springer-Verlag New York, Inc., 175 Fifth Avenue, New York, NY, 10010 and outside the United States by Springer-Verlag GmbH & Co. KG, Tiergartenstr. 17, 69112 Heidelberg, Germany.

In the United States: phone 1-800-SPRINGER, email orders@springer-ny.com, or visit http://www.springer-ny.com. Outside the United States: fax +49 6221 345229, email orders@springer.de, or visit http://www.springer.de.

For information on translations, please contact Apress directly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, email info@apress.com, or visit http://www.apress.com.

The information in this book is distributed on an "as is" basis, without warranty. Although every precaution has been taken in the preparation of this work, neither the author(s) nor Apress shall have any liability to any person or entity with respect to any loss or damage caused or alleged to be caused directly or indirectly by the information contained in this work.

The source code for this book is available to readers at http://www.apress.com in the Downloads section. You will need to answer questions pertaining to this book in order to successfully download the code.

Credits

Editorial Board
Dan Appleman
Craig Berry
Gary Cornell
Tony Davis
Steven Rycroft
Julian Skinner
Martin Streicher
Jim Sumser
Karen Watterson
Gavin Wray
John Zukowski

Managing Editor
Louay Fatoohi

Commissioning Editor
Douglas Paterson

Indexer
Andrew Criddle

Technical Editors
Arun Nair
Veena Nair

Technical Reviewers
Mike Ahern
Scott Allen
Natalia Bortniker
Cristian Darie
Louis Davidson
Mike Faulkinbury
Brian Knight
John Boyd Nolan
Morgan Skinner
Sakhr Youness

Production Coordinator
Sarah Hall

Proof Reader
Dev Lunsford

Cover Design
Kurt Krames

Project Managers
Safiulla Shakir
Charlotte Smith

About the Authors

Tony Bain

Tony Bain is the founder of Tony Bain & Associates and he has worked with SQL Server for the last 6 last years. Tony is passionate about all database technologies especially when they relate to enterprise availability and scalability.

Tony spends a lot of his time writing and presenting database topics and he currently has Microsoft Certified System Engineer, Microsoft Certified Solution Developer, and Microsoft Certified Database Administrator certification.

Thanks to Linda, Laura, Stephanie, and William for their continued support and thanks also to Craig Walker who is a .NET legend!

Louis Davidson

Louis Davidson has been in the technology industry for ten years, as a corporate database developer and architect. Currently, he is serving as a Database Administrator for Compass Technology Management in their Nashville Data Center supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN.

Davidson has a bachelor's degree from the University of Tennessee at Chattanooga in computer science with a minor in mathematics (though the minor in mathematics is more of an indication to how much math UTC required to get the CS degree, rather than any great love or skill in the subject).

The majority of his experience, with slight deviations into Visual Basic, has been spent with Microsoft SQL Server from version 1.0 to the latest version that is in Beta. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he has written numerous stored procedures and triggers throughout the years, though he seldom has the need anymore with the code generation tools he has developed to generate objects, with only a few procedures and triggers to code from the ground up.

Louis has published "Professional SQL Server 2000 Database Design," also by Apress. The book follows the complete arc of developing a database through requirements, architecture, and design. He has also been an active volunteer with SQL PASS as a presenter and a chairperson in their special interest groups. It has been said that in his ridiculously small amount of spare time, he tends to play a lot of Nintendo (got to save that darn Princess, she went off and was captured by the silly dragon, again!) and watch a great deal of television. Most notably, his favorites are old English programs (the Avengers, The Saint, Monty Python, and Blackadder to name a few). Quite often, this spare time is also spent with his notebook computer writing something pertaining to SQL.

Robin Dewson

Robin has come a long way since the early heady days of the Sinclair ZX80/81 and Spectrum. He was first introduced to computers at an exhibition in Glasgow where he saw a Commodore Pet manipulate a robot and he knew instantly that computers was the route for him. Unfortunately that route initially took him into IBM mainframes.

However, he feels that this is a crucial keystone in his overall approach to computing and without this he would not be where he is today. Well, that, Scottish College of Textiles, his family and of course many, many bottles of Irn Bru (who needs caffeine?). Robin moved to working with PCs nearly 10 years ago with FoxBASE and has moved from there through Visual FoxPro, Visual Basic, Sybase, and of course SQL Server.. Robin can be contacted at robin@fat-belly.com.

There are many people once again that I would like to thank for different reasons. All those at Wrox throughout the years but especially Cilmara, Douglas, Cath, Helen, James, and Chris for different reasons, but thanks! Andy at Pinball Mania for keeping my pinball machines working, Charlie and Debbie at Sea Palling in Norfolk for being two great friends and brilliant with my children in their arcade, Phill Jupitus, Phil (2112 rules!) Wilding, Gideon Coe, Liz Kershaw, and Andrew Collins at the BBC's 6Music, (http://www.bbc.co.uk/6music) for the excellent music and humor to keep me going at work, all my traders at Lehmans but especially Anthony "Jock" Jawad for his staunch support, and my good friend Jack Mason. Of course special thanks though to my mum and dad for sorting out this great life for me, my sister Carol and her family, Eleanor, Erin, and Lucas out in Australia but most of all my wife Julie who goes through hell with each book I write. I am afraid this was "not another one". But you can now go and enjoy the Donny Osmond concert. Also my 3 long suffering kids, Scott, Cameron, and Ellen. Let's go and see a movie.

Up the Blues. (http://www.bedfordrugby.co.uk)

Chuck Hawkins

Chuck is a senior consultant and database administrator in Virginia Beach, Virginia. Working for Compass Technology Management, he currently manages the daily ups and downs of multiple servers for several large ministries. He has extensive experience in T-SQL programming, replication, performance tuning, developer management, and routine server management.

Chuck has spoken at Professional Association for SQL Server conferences in Chicago, London, Denver, and Seattle. He has contributed columns to several magazines and was a contributing author for Louis Davidson's "Professional SQL Server 2000 Database Design," now published by Apress. Prior to his life as a computing professional, Chuck taught English in Japan for five years.

Chuck is happily married to Kathy and adopted Kristina from Russia five years ago on Christmas Day. When not working with databases, he likes to play with Kristina, run long distances, and read "First Things" journal. You can get in touch with Chuck at chuck@sqlserver.cc.




SQL Server 2000 Stored Procedures Handbook
SQL Server 2000 Stored Procedures Handbook (Experts Voice)
ISBN: 1590592875
EAN: 2147483647
Year: 2005
Pages: 100

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net