Beginning SQL Server 2005 Express for Developers.pdf

(11058 KB) Pobierz
373584445 UNPDF
THE EXPERT’S VOICE ® IN .NET
SQL Server
2005 Express
for Developers
From Novice to Professional
Everything you need to be productive with SQL Server 2005 Express
Robin Dewson
Beginning
373584445.040.png 373584445.050.png 373584445.059.png 373584445.067.png 373584445.001.png 373584445.002.png 373584445.003.png 373584445.004.png 373584445.005.png 373584445.006.png 373584445.007.png 373584445.008.png 373584445.009.png 373584445.010.png 373584445.011.png 373584445.012.png 373584445.013.png 373584445.014.png 373584445.015.png 373584445.016.png 373584445.017.png 373584445.018.png 373584445.019.png 373584445.020.png 373584445.021.png 373584445.022.png 373584445.023.png 373584445.024.png 373584445.025.png 373584445.026.png 373584445.027.png
 
373584445.028.png
 
373584445.029.png
 
373584445.030.png
 
373584445.031.png
 
373584445.032.png 373584445.033.png 373584445.034.png 373584445.035.png 373584445.036.png 373584445.037.png 373584445.038.png 373584445.039.png 373584445.041.png 373584445.042.png 373584445.043.png
 
373584445.044.png 373584445.045.png 373584445.046.png 373584445.047.png 373584445.048.png 373584445.049.png 373584445.051.png 373584445.052.png 373584445.053.png 373584445.054.png 373584445.055.png 373584445.056.png 373584445.057.png 373584445.058.png 373584445.060.png 373584445.061.png 373584445.062.png 373584445.063.png 373584445.064.png 373584445.065.png
Beginning SQL Server
2005 Express
for Developers
From Novice to Professional
Robin Dewson
373584445.066.png 373584445.068.png 373584445.069.png
Beginning SQL Server 2005 Express for Developers: From Novice to Professional
Copyright © 2007 by Robin 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 United States 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 Eddy
Indexer: 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 Apress directly 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 with respect 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.
373584445.070.png
Contents at a Glance
About the Author . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xiii
About the Technical Reviewer . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xv
Acknowledgments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xvii
Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xix
CHAPTER 1
SQL Server 2005 Express Overview and Installation . . . . . . . . . . . . . . . . . . 1
CHAPTER 2
SQL Server Management Studio Express . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
CHAPTER 3
Database Design and Creation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45
CHAPTER 4
Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85
CHAPTER 5
Defining Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
CHAPTER 6
Creating Indexes and Database Diagramming . . . . . . . . . . . . . . . . . . . . . . 137
CHAPTER 7
Database Backup, Recovery, and Maintenance . . . . . . . . . . . . . . . . . . . . 167
CHAPTER 8
Working with the Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209
CHAPTER 9
Building a View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267
CHAPTER 10
Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291
CHAPTER 11
T-SQL Essentials . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313
CHAPTER 12
Advanced T-SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351
CHAPTER 13
Triggers . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 373
CHAPTER 14
SQL Server 2005 Reporting Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 395
APPENDIX
Glossary of Terms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 415
INDEX . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 425
iii
n
n
n
n
n
n
n
n
n
n
n
n
n
n
n
n
373584445.071.png
373584445.072.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin