Learning SQL on SQL Server

by Sikha Saha Bagui and Richard Walsh Earp

Printed in the United States of America.

Published by O'Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472.

O'Reilly books may be purchased for educational, business, or sales promotional use. Online editions are also available for most titles (safari.oreilly.com). For more information, contact our corporate/institutional sales department: (800) 998-9938 or corporate@oreilly.com.

Editor:

Jeff Pepper

Production Editor:

Philip Dangler

Copyeditor:

Nancy Wolfe Kotary

Indexer:

Johnna VanHoose Dinse

Cover Designer:

Karen Montgomery

Interior Designer:

David Futato

Cover Illustration:

Dover Pictoral Archive

Illustrators:

Robert Romano and Jessamyn Read

Printing History:

April 2006:

First Edition.

Nutshell Handbook, the Nutshell Handbook logo, and the O'Reilly logo are registered trademarks of O'Reilly Media, Inc. Learning SQL on SQL Server , the image of a ribbed newt, and related trade dress are trademarks of O'Reilly Media, Inc.

Adapted with permission from Learning SQL: Step-by-Step GD Using Oracle by Bagui and Earp, pp. 48-61, 69-70, 85, 89-93, 105-108, 109-110, 114-120, 122-129, 131-133, 135-152,153-166, 167-183, 185-213, Appendix 3, and Glossary of Terms, © 2003 Pearson Education, Inc. Reprinted by permission of Pearson Education, Inc., Publishing as Pearson Addison-Wesley. All rights reserved.

Adaptated with permission from, Learning SQL: Step-by-Step GD Using Access by Bagui and Earp, pp. 64-77, © 2003 Pearson Education, Inc. Reproduced by permission of Pearson Education, Inc. Publishing as Pearson Addison Wesley. All rights reserved.

Oracle® and all Oracle-based trademarks and logos are trademarks or registered trademarks of Oracle Corporation, Inc. in the United States and other countries. O'Reilly Media, Inc. is independent of Oracle Corporation.

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and O'Reilly Media, Inc. was aware of a trademark claim, the designations have been printed in caps or initial caps.

While every precaution has been taken in the preparation of this book, the publisher and authors assume no responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

ISBN: 0-596-10215-1

[M]