Sql server® 2012 t-sql fundamentals

vector expressions

412  

Index

vector expressions,  268

Venn diagram,  192

VertiPaq, 11

views, 169–176

catalog views,  88

information schema views,  89

options, 172–176

CHECK OPTION,  174

ENCRYPTION, 172

SCHEMABINDING, 174

ORDER BY clause,  170

sys.dm_tran_locks view,  306

Visual Studio. See Microsoft Visual Studio

W

WHEN MATCHED,  273

WHEN MATCHED AND,  274

WHEN NOT MATCHED,  273

WHEN NOT MATCHED BY SOURCE,  273

WHERE

about, 31

DELETE,  262, 263

outer joins,  112, 115

UPDATE based on joins,  267

WHILE, 346

whole, set theory,  3

wildcards, LIKE predicate,  71

window functions,  211–222

about, 48

aggregates,  220, 352

offset window functions,  217–219

ORDER BY,  196

ranking, 214–217

Windows authenticated logon,  17

Windows Azure platform account,  376

Windows Azure SQL Database

about, 13

collation, 63

databases, 20

database triggers,  368

default isolation levels,  301, 310

engine, 13

getting started,  375

global temporary variables,  355

heaps, 251

logical layer,  17

READ COMMITTED,  303

system database master,  16

Windows Live ID,  376

WITH NOCHECK option,  24

WITH statement, CTEs,  163

WITH TIES,  152

Y

YEAR function,  85

www.it-ebooks.info

---

about the author

ITzIK BEN-GAN

 is a mentor with and co-founder of SolidQ. A SQL Server 

Microsoft MVP since 1999, Itzik has taught numerous training events around 

the world focused on T-SQL querying, query tuning, and programming. Itzik 

is the author of several books about T-SQL. He has written many articles for 

SQL Server Pro as well as articles and white papers for MSDN and The SolidQ 

Journal. Itzik’s speaking engagements include Tech-Ed, SQL PASS, SQL Server 

Connections, presentations to various SQL Server user groups, and SolidQ events. Itzik 

is a subject-matter expert within SolidQ for its T-SQL related activities. He authored 

SolidQ’s Advanced T-SQL and T-SQL Fundamentals courses and delivers them regularly 

worldwide.

www.it-ebooks.info

---

What do  

you think of  

this book?

We want to hear from you! 

To participate in a brief online survey, please visit: 

Tell us how well this book meets your needs —what works effectively, and what we can  

do better. Your feedback will help us continually improve our books and learning  

resources for you.   

Thank you in advance for your input

!

microsoft.com/learning/booksurvey

 

SurvPage_Corp_02.indd   1

5/19/2011   4:18:12 PM

www.it-ebooks.info

---