Microsoft SQL Server 2012 T-SQL Fundamentals

所需积分/C币:50 2012-08-08 12:19:28 7.1MB PDF
收藏 收藏
举报

Gain a solid understanding of T-SQL—and write better queries Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then
Microsoft Microsoft SQL Server 2012T-SQL Fundamentals Itzik Ben -Gan Published with the authorization of Microsoft Corporation by O'Reilly Media, Inc 1005 Gravenstein Highway North Sebastopol, California 95472 Copyright 2012 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 SBN:978-0-735-65814-1 123456789M765432 Printed and bound in the united states of america Microsoft Press books are available through booksellers and distributors worldwide. If you need support related tothisbook,emailMicrosoftPressBookSupportatmspinput@microsoft.com.Pleasetelluswhatyouthinkof thisbookathttp://www.microsoft.com/learning/booksurvey Microsoftandthetrademarkslistedathttp://www.microsoft.com/aboutlegal/en/us/intellectualproperty/ Trademarks/EN-US. aspx are trademarks of the microsoft group of companies. All other marks are property of their respective owners The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. no association with any real company, organization, product, domain name email address, logo, person, place, or event is intended or should be inferred This book expresses the authors views and opinions. the information contained in this book is provided without any express, statutory, or implied warranties. Neither the author, O'Reilly Media, Inc, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book Acquisitions and developmental Editor: Russell Jones Production Editor: Kristen Borg Editorial Production and Illustration: Online Training Solutions, Inc Technical Reviewer: Gianluca Hotz and herbert albert Copyeditor: Kathy Krause Indexer Allegro Technical Indexing Cover Design: Twist Creative. Seattle Cover Composition: Karen Montgomery To Dato To live in hearts we leave behind Is not to die -THOMAS CAMPBELL Contents at a glance Foreword ⅩX Introduction CHAPTER 1 Background to T-SQL Querying and Programming CHAPTER 2 Single-Table queries 27 ChAPTER 3 Joins 99 CHAPTER 4 Subqueries 129 CHAPTER 5 Table Expressions 157 CHAPTER 6 Set operators 191 CHAPTER 7 Beyond the Fundamentals of Querying 211 ChaPteR 8 Data modification 247 ChaPteR 9 Transactions and Concurrency 297 CHAPTER 10 Programmable objects 339 APPENDIX A Getting Started 375 Index 397 About the author 413 Contents Foreword ⅩX Introduction Chapter 1 Background to T-SQL Querying and Programming Theoretical Background SQL Set Theory Predicate Logic ....... The relational model 1123449 The data Life cycle SOL Server Architecture 12 The Abc Flavors of sql server 12 SQL Server Instances .14 Databases ..15 Schemas and Objects 18 Creating Tables and Defining Data Integrity ...19 Creating Tables 19 Defining Data Integrity Conclusⅰon Chapter 2 Single-Table Queries 27 Elements of the select statement 27 The From Clause 29 The where clause The grouP By Clause What do you think of this book? We want to hear from you! Microsoft is interested in hearing your feedback so we can continually improve our books and learning resources for you. To participate in a brief online survey, please visit microsoft. com/learning/booksurvey The having clause 36 The select clause 36 The Order BY Clause .......42 The ToP and OFFSET-FETCH Filters 44 A Quick Look at Window Functions 48 Predicates and Operators 50 CASE EXpressions... 53 NULL Marks 55 All-at-Once Operations Working with Character Data 61 ta Types 61 Collation 62 Operators and Functions 64 The LIKE Predicate 71 Working with date and time data 73 Date and Time Data Type 73 Literals 74 Working with Date and Time Separately 78 Filtering date ranges 79 Date and time functi 80 Querying Metada 88 Catalog views 88 Information Schema Views ......89 System Stored Procedures and Functions 89 Conclusion 91 Exercis 92 92 92 93 94 94

...展开详情
试读 127P Microsoft SQL Server 2012 T-SQL Fundamentals
立即下载 低至0.43元/次 身份认证VIP会员低至7折
一个资源只可评论一次,评论内容不能少于5个字
syzdjf 还不错的资源
2019-11-13
回复
yczf1836 蛮好用的书
2017-04-17
回复
tinaturnerxu MS database server 入门。 一般
2017-01-23
回复
lihongg good book, worth a reading
2017-01-06
回复
Redredhot sql基础书籍,英文版的,适合有英语基础的人阅读
2016-08-02
回复
xatx1 我仅仅是参考下,所以读的不深, 不过如果SQL 的基础好,读起来应该很快的
2015-10-14
回复
sashengdaxue 质量很好,很清楚。不错的书!
2015-10-13
回复
guanjing 整本,清晰,高质量的材料。初学者,大牛推荐的。
2015-09-16
回复
zhang88cam 入门学习中!
2015-06-29
回复
shmff 不错, 非常清晰的版本,而且没有水印
2015-02-05
回复
关注 私信 TA的资源
上传资源赚积分,得勋章
最新推荐
Microsoft SQL Server 2012 T-SQL Fundamentals 50积分/C币 立即下载
1/127
Microsoft SQL Server 2012 T-SQL Fundamentals第1页
Microsoft SQL Server 2012 T-SQL Fundamentals第2页
Microsoft SQL Server 2012 T-SQL Fundamentals第3页
Microsoft SQL Server 2012 T-SQL Fundamentals第4页
Microsoft SQL Server 2012 T-SQL Fundamentals第5页
Microsoft SQL Server 2012 T-SQL Fundamentals第6页
Microsoft SQL Server 2012 T-SQL Fundamentals第7页
Microsoft SQL Server 2012 T-SQL Fundamentals第8页
Microsoft SQL Server 2012 T-SQL Fundamentals第9页
Microsoft SQL Server 2012 T-SQL Fundamentals第10页
Microsoft SQL Server 2012 T-SQL Fundamentals第11页
Microsoft SQL Server 2012 T-SQL Fundamentals第12页
Microsoft SQL Server 2012 T-SQL Fundamentals第13页
Microsoft SQL Server 2012 T-SQL Fundamentals第14页
Microsoft SQL Server 2012 T-SQL Fundamentals第15页
Microsoft SQL Server 2012 T-SQL Fundamentals第16页
Microsoft SQL Server 2012 T-SQL Fundamentals第17页
Microsoft SQL Server 2012 T-SQL Fundamentals第18页
Microsoft SQL Server 2012 T-SQL Fundamentals第19页
Microsoft SQL Server 2012 T-SQL Fundamentals第20页

试读结束, 可继续阅读

50积分/C币 立即下载 >