Wrox - Professional SQL Server 2005 CLR Programming (2007).pdf - MS SQL 2005 Server - adszy1

Professional SQL Server ™ 2005

CLR Programming

with Stored Procedures,

Functions, Triggers,

Aggregates, and Types

Derek Comingore

Douglas Hinson

Professional SQL Server ™ 2005 CLR Programming with Stored

Procedures, Functions, Triggers, Aggregates, and Types

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Published simultaneously in Canada

ISBN-13: 978-0-470-05403-1

ISBN-10: 0-470-05403-4

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

1MA/RX/RR/QW/IN

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 REPRESENTA-

TIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS 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 UNDERSTANDING THAT THE PUBLISHER IS NOT ENGAGED IN RENDERING LEGAL, ACCOUNTING,

OR OTHER PROFESSIONAL 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 INFORMATION DOES NOT MEAN THAT THE AUTHOR OR

THE PUBLISHER ENDORSES THE INFORMATION THE ORGANIZATION OR WEBSITE MAY PROVIDE OR RECOMMENDA-

TIONS IT MAY MAKE. FURTHER, READERS SHOULD BE AWARE THAT INTERNET WEBSITES LISTED IN THIS WORK MAY

HAVE CHANGED OR DISAPPEARED BETWEEN WHEN THIS WORK WAS WRITTEN AND WHEN IT IS READ.

For general information on our other products and services or to obtain technical support, please contact our Customer

Care Department within the U.S. at (800) 762-2974, outside the U.S. at (317) 572-3993 or fax (317) 572-4002.

Library of Congress Cataloging-in-Publication Data

Comingore, Derek, 1978-

Professional SQL server 2005 CLR programming : with stored procedures, functions, triggers, aggregates, and types /

Derek Comingore and Douglas Hinson.

p. cm.

Includes indexes.

ISBN-13: 978-0-470-05403-1 (paper/website)

ISBN-10: 0-470-05403-4 (paper/website)

1. SQL (Computer program language) 2. Database management--Computer programs. 3. Microsoft .NET Framework. I.

Hinson, Douglas, 1968- II. Title.

QA76.73.S67C655 2007

005.75’85--dc22

2006031028

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

marks 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.

To my son, Derek Steven Comingore, and the next generation

of programmers.

— Derek Comingore

To Misty, Mariah, and Kyle, for your love, support, and patience.

— Douglas Hinson

About the Authors

Derek Comingore is an independent consultant, trainer, and speaker specializing in SQL Server and .NET

technologies. He has recently started two ventures, an online Microsoft community for colleagues to learn

from one another, located at www.RedmondSociety.com , and a second for SQL Server consulting at

www.SQLServerDBAs.com . Derek holds the MCAD/MCDBA Microsoft certifications, the Carnegie Mellon

Personal Software Process (PSP) credential, and an AAS/BS in Computer Information Systems from

University of North Dakota. Derek’s blog is located at http://RedmondSociety.com/blogs/Derek .

Douglas Hinson has worked as an independent software and database consultant in the logistics and

financial industries, with an extensive SQL Server background. He has coauthored several Wrox books,

including Professional SQL Server 2005 Integration Services .

Wrox - Professional SQL Server 2005 CLR Programming (2007).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: