Professional SQL Server 2005 Programming.pdf

Professional

SQL Server ™ 2005 Programming

Robert Vieira

Professional SQL Server ™ 2005 Programming

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Published simultaneously in Canada

ISBN-13: 978-0-7645-8434-3

ISBN-10: 0-7645-8434-0

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

1B/QW/RR/QW/IN

Library of Congress Cataloging-in-Publication Data:

Vieira, Robert.

Professional SQL server 2005 programming / Robert Vieira.

p. cm.

ISBN-13: 978-0-7645-8434-3 (paper/website)

ISBN-10: 0-7645-8434-0 (paper/website)

1. Client/server computing. 2. SQL server. I. Title.

QA76.9.C55V55 2006

005.2’768—dc22

2006023047

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any

means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections

107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or

authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood

Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be

addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317)

572-3447, fax (317) 572-4355, or online at http://www.wiley.com/go/permissions.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REP-

RESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CON-

TENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITHOUT

LIMITATION WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED

OR EXTENDED BY SALES OR PROMOTIONAL MATERIALS. THE ADVICE AND STRATEGIES CONTAINED

HEREIN MAY NOT BE SUITABLE FOR EVERY SITUATION. THIS WORK IS SOLD WITH THE UNDERSTAND-

ING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING, OR OTHER PROFES-

SIONAL SERVICES. IF PROFESSIONAL ASSISTANCE IS REQUIRED, THE SERVICES OF A COMPETENT

PROFESSIONAL PERSON SHOULD BE SOUGHT. NEITHER THE PUBLISHER NOR THE AUTHOR SHALL BE

LIABLE FOR DAMAGES ARISING HEREFROM. THE FACT THAT AN ORGANIZATION OR WEBSITE IS

REFERRED TO IN THIS WORK AS A CITATION AND/OR A POTENTIAL SOURCE OF FURTHER INFORMA-

TION DOES NOT MEAN THAT THE AUTHOR OR THE PUBLISHER ENDORSES THE INFORMATION THE

ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDATIONS IT MAY MAKE. FURTHER, READ-

ERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY HAVE CHANGED OR DIS-

APPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services please contact our Customer Care Department within

the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Programmer to Programmer, and related trade dress are

trademarks or registered trademarks of John Wiley & Sons, Inc. and/or its affiliates, in the United States and other

countries, and may not be used without written permission. SQL Server is a trademark of Microsoft Corporation in

the United States and/or other countries. All other trademarks are the property of their respective owners. Wiley

Publishing, Inc., is not associated with any product or vendor mentioned in this book.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be

available in electronic books.

Credits

Executive Editor

Bob Elliott

Vice President and Executive Group Publisher

Richard Swadley

Senior Development Editor

Kevin Kent

Vice President and Executive Publisher

Joseph B. Wikert

Technical Editor

John Mueller

Graphics and Production Specialists

Denny Hager, Jennifer Mayberry, Barbara Moore,

Lynsey Osborn, Heather Ryan, Alicia B. South,

Ronald Terry

Production Editor

Pamela Hanley

Copy Editor

Foxxe Editorial Services

Quality Control Technician

John Greenough

Editorial Manager

Mary Beth Wakefield

Project Coordinators

Michael Kruzil, Kristie Rees

Production Manager

Tim Tate

Proofreading and Indexing

Techbooks

About the Author

Experiencing his first infection with computing fever in 1978, Robert Vieira knew right away that this

was something “really cool.” In 1980 he began immersing himself into the computing world more

fully—splitting his time between building and repairing computer kits and programming in BASIC as

well as Z80 and 6502 Assembly. In 1983, he began studies for a degree in Computer Information

Systems, but found the professional mainframe environment too rigid for his tastes and dropped out

in 1985 to pursue other interests. Later that year, he caught the “PC bug” and began the long road of

programming in database languages from dBase to SQL Server. Rob completed a degree in business

administration in 1990 and since has typically worked in roles that allow him to combine his unique

knowledge of business and computing. Beyond his bachelor’s degree, he has been certified as a

Certified Management Accountant; Microsoft Certified as a Solutions Developer (MCSD), Trainer

(MCT), and Database Administrator (MCDBA); and even had a brief stint certified as an emergency

medical technician (EMT).

Rob is currently self-employed as a high-level consultant specializing in architectural analysis, long-term

planning, and product viability analysis and is recognized internationally for his expertise in database

architecture and management. He has published four books on SQL Server development.

He resides with his daughters Ashley and Adrianna in Vancouver, Washington.

This book is dedicated with all my heart to my children Ashley and Addy ,

who put up with me “disappearing” into my home office during the

several months that I worked on this book. They provide the energy

that powers my writing, and I love them to no end. I only wish

Wrox would let me print a picture of the two women

in my life on the cover of this book rather than my ugly mug.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: