T-SQL Fundamentals - 3rd Edition (2016).pdf

(25264 KB) Pobierz
T-SQL Fundamentals, Third Edition
Itzik Ben-Gan
PUBLISHED BY
Microsoft Press
A division of Microsoft Corporation
One Microsoft Way
Redmond, Washington 98052-6399
Copyright © 2016 by Itzik Ben-Gan
All rights reserved. No part of the contents of this book may be reproduced or transmitted in
any form or by any means without the written permission of the publisher.
Library of Congress Control Number: 2015955815
ISBN: 978-1-5093-0200-0
Printed and bound in the United States of America.
First Printing
Microsoft Press books are available through booksellers and distributors worldwide. If you
need support related to this book, email Microsoft Press Support at mspinput@microsoft.com.
Please tell us what you think of this book at http://aka.ms/tellpress.
This book is provided “as-is” and expresses the author ’s views and opinions. The views,
opinions and information expressed in this book, including URL and other Internet website
references, may change without notice.
Some examples depicted herein are provided for illustration only and are fictitious. No real
association or connection is intended or should be inferred.
Microsoft and the trademarks listed at http://www.microsoft.com on the “Trademarks”
webpage are trademarks of the Microsoft group of companies. All other marks are property
of their respective owners.
Acquisitions Editor: Devon Musgrave
Developmental Editor: Carol Dillingham
Project Editor: Carol Dillingham
Editorial Production: Christian Holdener; S4Carlisle Publishing Services
Technical Reviewer: Bob Beauchemin; Technical Review services provided by Content
Master, a member of CM Group, Ltd.
Copyeditor: Roger Leblanc
Indexer: Maureen Johnson, MoJo’s Indexing Services
Cover: Twist Creative • Seattle and Joel Panchot
To Dato,
To live in hearts we leave behind,
Is not to die.
—T
HOMAS
C
AMPBELL
Contents at a glance
Introduction
CHAPTER 1
Background to T-SQL querying and programming
CHAPTER 2
Single-table queries
CHAPTER 3
Joins
CHAPTER 4
Subqueries
CHAPTER 5
Table expressions
CHAPTER 6
Set operators
CHAPTER 7
Beyond the fundamentals of querying
CHAPTER 8
Data modification
CHAPTER 9
Temporal tables
CHAPTER 10
Transactions and concurrency
CHAPTER 11
Programmable objects
Appendix: Getting started
Index

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin