Microsoft® SQL Server

Microsoft® SQL Server® 2008

FOR

DUMmIES‰

by Mike Chapple

Microsoft® SQL Server® 2008

FOR

DUMmIES‰

Microsoft® SQL Server® 2008

FOR

DUMmIES‰

by Mike Chapple

Microsoft® SQL Server® 2008 For Dummies®

Published by

Wiley Publishing, Inc.

111 River Street Hoboken, NJ 07030-5774 www.wiley.com

Copyright © 2008 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Published simultaneously in Canada

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 permit- ted 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.

Trademarks: Wiley, the Wiley Publishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com, Making Everything Easier, 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 registered 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.

LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: THE PUBLISHER AND THE AUTHOR MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS WORK AND SPECIFICALLY DISCLAIM ALL WARRANTIES, INCLUDING WITH- OUT 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 ORGANIZA- TION 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 RECOMMENDATIONS 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, 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.

For technical support, please visit www.wiley.com/techsupport.

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

Library of Congress Control Number: 2008933745

ISBN: 978-0-470-22465-6

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

About the Author

Mike Chapple, MCDBA, CISA, CISSP is an IT professional with over ten years’ experience with SQL Server. He currently serves as an IT profes- sional with the University of Notre Dame, where he also teaches an undergraduate computer applications course. Mike actively participates as a subject matter expert in the SQL Server community and writes extensively on SQL Server at the About.com Guide to Databases. He also serves on the Center for Internet Security SQL Server security standard development team.

Mike is a technical editor for Information Security Magazine and is author of several books, including Information Security Illuminated and the CISSP Prep Guide. Mike holds a BS in computer science from the University of Notre Dame, an MS in computer science from the University of Idaho, and an MBA from Auburn University.

Dedication

To my family: Renee, Richard, Matthew, and Christopher who lovingly put up with me during the hours I spent buried in my laptop writing this book.

Author’s Acknowledgments

I would like to thank Kyle Looper and Susan Christophersen, my editors at Wiley, who provided me with invaluable assis- tance throughout the book development process. I also owe a debt of gratitude to my literary agent, Carole Jelen of Waterside Productions. Doug Couch served as technical editor for this title and was a great source of advice as we worked through some of the more difficult portions of the book. I’d also like to thank the many people who participated in the production of this book but I never had the chance to meet: the graphics team, production staff, and all those involved in bringing this book to press.

Publisher’s Acknowledgments

We’re proud of this book; please send us your comments through our online registration form located at www.dummies.com/register/.

Some of the people who helped bring this book to market include the following:

Acquisitions, Editorial, and

Media Development

Project Editor: Susan Christophersen Acquisitions Editor: Kyle Looper Copy Editor: Susan Christophersen Technical Editor: Doug Couch Editorial Manager: Jodi Jensen

Editorial Assistant: Amanda Foxworth

Sr. Editorial Assistant: Cherie Case

Cartoons: Rich Tennant

(www.the5thwave.com)

Composition Services

Project Coordinator: Katherine Key

Layout and Graphics: Carl Byers, Reuben W. Davis

Proofreader: Toni Settle

Indexer: Broccoli Information Management

Publishing and Editorial for Technology Dummies

Richard Swadley, Vice President and Executive Group Publisher

Andy Cummings, Vice President and Publisher Mary Bednarek, Executive Acquisitions Director Mary C. Corder, Editorial Director

Publishing for Consumer Dummies

Diane Graves Steele, Vice President and Publisher

Joyce Pepple, Acquisitions Director

Composition Services

Gerry Fahey, Vice President of Production Services

Debbie Stailey, Director of Composition Services

Contents at a Glance

Introduction ................................................................ 1

Part I: Welcome to SQL Server 2008............................. 7

Chapter 1: Introducing SQL Server 2008 ......................................................................... 9

Chapter 2: Building Your SQL Server ............................................................................ 19

Chapter 3: Working with SQL Server Tools .................................................................. 35

Part II: Building SQL Server 2008 Databases .............. 49

Chapter 4: Planning Your Database............................................................................... 51

Chapter 5: Creating Databases and Tables................................................................... 73

Chapter 6: Imposing Constraints and Relationships................................................... 91

Part III: Retrieving Data from Databases................... 107

Chapter 7: Constructing Simple Database Queries ................................................... 109

Chapter 8: Joins and Other Advanced Queries.......................................................... 127

Chapter 9: Turning Data into Information with SQL Server

Reporting Services ...................................................................................................... 143

Part IV: Inserting and Manipulating Your Data.......... 159

Chapter 10: Inserting, Updating, and Deleting Data .................................................. 161

Chapter 11: Saving Time with Functions, Stored Procedures, and Triggers.......... 175

...