Algo de que no hablar de informática.

THE EXPERT’S VOICE ® IN .NET

Beginning

SQL Server 2005 Express
for Developers
From Novice to Professional
Everything you need to be productive with SQL Server 2005 Express

Robin Dewson

Beginning SQL Server 2005 Express for Developers
From Novice to Professional

Robin Dewson

Beginning SQL Server 2005 Express for Developers: From Novice to Professional Copyright © 2007 byRobin Dewson
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. ISBN-13 (pbk): 978-1-59059-720-0 ISBN-10 (pbk): 1-59059-720-6 Printed and bound in the UnitedStates of America 9 8 7 6 5 4 3 2 1 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. Lead Editor: James Huddleston Technical Reviewer: Vidya Vrat Agarwal Editorial Board: Steve Anglin,Ewan Buckingham, Gary Cornell, Jason Gilmore, Jonathan Gennick, Jonathan Hassell, James Huddleston, Chris Mills, Matthew Moodie, Dominic Shakeshaft, Jim Sumser, Matt Wade Project Manager: Kylie Johnston Copy Edit Manager: Nicole Flores Copy Editor: Ami Knox Assistant Production Director: Kari Brooks-Copony Production Editor: Kelly Winquist Compositor: Lynn L'Heureux Proofreader: April EddyIndexer: Broccoli Information Management Cover Designer: Kurt Krames Manufacturing Director: Tom Debolski Distributed to the book trade worldwide by Springer-Verlag New York, Inc., 233 Spring Street, 6th Floor, 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 contact Apressdirectly at 2560 Ninth Street, Suite 219, Berkeley, CA 94710. Phone 510-549-5930, fax 510-549-5939, e-mail 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 withrespect 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 Source Code/ Download section.

Contents at a Glance

About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . xiii About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix

I CHAPTER 1 I CHAPTER 2 I CHAPTER 3 I CHAPTER 4 I CHAPTER 5 I CHAPTER 6 I CHAPTER 7 I CHAPTER 8 I CHAPTER 9 I CHAPTER 10 I CHAPTER 11 I CHAPTER 12 I CHAPTER 13 I CHAPTER 14 I APPENDIX

SQL Server 2005 Express Overview and Installation . . . . . . . . . . . . . . . . . . 1 SQL Server Management Studio Express . . . . . . .. . . . . . . . . . . . . . . . . . . . 21 Database Design and Creation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Defining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105...