Expert SQL Server 2008 Development- P1

Chuyên viên phát triển SQL Server 2008 là nhằm mục đích phát triển SQL Server đã sẵn sàng để di chuyển vượt ra ngoài Sách Online. Tác giả và nhà phát triển có kinh nghiệm Alastair Aitchison cho bạn thấy làm thế nào để suy nghĩ về phát triển SQL Server như thể nó là bất kỳ loại hình khác phát triển. Youll tìm hiểu để quản lý các thử nghiệm trong SQL Server và đúng đối phó với các lỗi và ngoại lệ. Cuốn sách cũng bao gồm các quan trọng, là trung tâm cơ sở dữ liệu các...
Nội dung trích xuất từ tài liệu:
Expert SQL Server 2008 Development- P1THE EXPERT’S VOICE ® IN SQL SERVERExpertSQL Server 2008Development Advanced SQL Server techniques for database professionalsAlastair Aitchison and Adam Machanic Expert SQL Server 2008 DevelopmentAlastair AitchisonAdam MachanicExpert SQL Server 2008 DevelopmentCopyright © 2009 by Alastair Aitchison and Adam MachanicAll rights reserved. No part of this work may be reproduced or transmitted in any form or by anymeans, electronic or mechanical, including photocopying, recording, or by any information storage orretrieval system, without the prior written permission of the copyright owner and the publisher.ISBN-13 (pbk): 978-1-4302-7213-7ISBN-13 (electronic): 978-1-4302-7212-0Printed and bound in the United States of America 9 8 7 6 5 4 3 2 1Trademarked names may appear in this book. Rather than use a trademark symbol with everyoccurrence of a trademarked name, we use the names only in an editorial fashion and to the benefit ofthe trademark owner, with no intention of infringement of the trademark. President and Publisher: Paul Manning Lead Editor: Jonathan Gennick Technical Reviewer: Evan Terry Editorial Board: Clay Andres, Steve Anglin, Mark Beckner, Ewan Buckingham, Gary Cornell, Jonathan Gennick, Jonathan Hassell, Michelle Lowman, Matthew Moodie, Duncan Parkes, Jeffrey Pepper, Frank Pohlmann, Douglas Pundick, Ben Renow-Clarke, Dominic Shakeshaft, Matt Wade, Tom Welsh Coordinating Editor: Mary Tobin Copy Editor: Damon Larson Compositor: Bytheway Publishing Services Indexer: Barbara Palumbo Artist: April Milne Cover Designer: Anna IshchenkoDistributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6thFloor, New York, NY 10013. Phone 1-800-SPRINGER, fax 201-348-4505, e-mail orders-ny@springer-sbm.com, or visit http://www.springeronline.com.For information on translations, please e-mail info@apress.com, or visit http://www.apress.com.Apress and friends of ED books may be purchased in bulk for academic, corporate, or promotionaluse. eBook versions and licenses are also available for most titles. For more information, reference ourSpecial Bulk Sales–eBook Licensing web page at http://www.apress.com/info/bulksales.The information in this book is distributed on an “as is” basis, without warranty. Although everyprecaution has been taken in the preparation of this work, neither the author(s) nor Apress shall haveany liability to any person or entity with respect to any loss or damage caused or alleged to be causeddirectly or indirectly by the information contained in this work.The source code for this book is available to readers at http://www.apress.com. You will need toanswer questions pertaining to this book in order to successfully download the code.For Clare and Douglas CONTENTS Contents at a Glance Contents at a Glance.............................................................................................. iv Contents.................................................................................................................. v About the Author.................................................................................................. xvi About the Technical Reviewer ............................................................................ xvii Acknowledgments ............................................................................................. xviii Preface................................................................................................................. xix Chapter 1: Software Development Methodologies for the Database World ............1 Chapter 2: Best Practices for Database Programming .........................................23 Chapter 3: Testing Database Routines..................................................................49 Chapter 4: Errors and Exceptions .........................................................................71 Chapter 5: Privilege and Authorization...............................................................101 Chapter 6: Encryption .........................................................................................121 Chapter 7: SQLCLR: Architecture and Design Considerations.............................159 Chapter 8: Dynamic T-SQL ..................................................................................195 Chapter 9: Designing Systems for Application Concurrency ..............................235 Chapter 10: Working with Spatial Data...............................................................283 Chapter 11: Working with Temporal Data...........................................................321 Chapter 12: Trees, Hierarchies, and Graphs .......................................................371 Index ....................................................................................................................419ivContents Contents at a Glance .............................................................................................. iv Contents.................................................................................................................. v About the Author.................................................................................................. xvi About the Technical Reviewer ............................................................................ xvii Acknowledgments ............................................................................................. xviii Preface............................................................ ...