Sql server® 2012 t-sql fundamentals

ON

406  

Index

ON

ANSI SQL-89 syntax,  105

ANSI SQL-92 syntax,  103

multi-join queries,  116

outer joins,  112

online transactional processing (OLTP),  10

on-premises SQL Server,  13

operations, all-at-once operations,  59

operators

APPLY operator,  178–181, 306

arithmetic operators,  51

comparison operators,  51

CROSS APPLY operator,  179

logical operators,  51

OUTER APPLY operator,  179

plus sign (+) operator,  64

precedence rules,  52

SELECT, 50–53

optimistic concurrency,  301

optimization. See performance

order

rows in tables,  4

set elements,  3

SQL processing of query clauses,  28

table expressions,  158

ORDER BY

about, 42

circumventing unsupported logical phases,  202

cursors, 348

OFFSET-FETCH,  48, 277

set operators,  191

table expressions,  158

TOP,  44, 277

using, 49

views, 170

window functions,  196, 213

ordering

window ordering and aggregate functions,  221

windows functions,  212

OR operator,  51

OUTER APPLY,  178

outer joins,  110–119

about, 110–113

COUNT, 118

filtering attributes,  115

missing values,  113

multi-join queries,  116

outer queries, defined,  129

OUTPUT, 280–287

compostable DML,  285

DELETE, 282

INSERT, 280

MERGE, 284

UPDATE,  266, 283

using, 365

OVER

aggregate windows functions,  220

sequence objects,  259

window functions,  48, 211

P

Parallel Data Warehouse (PDW), appliances,  12

parameters, input parameters and inline table-

valued functions,  176

parentheses ()

column aliases in CTEs,  164

derived tables,  157

functions, 80

precedence, 52

parsing

batches as unit of parsing,  342

PARSE function,  81

PARTITION BY, window functions,  48, 213

PATINDEX function,  68

PDW (Parallel Data Warehouse), appliances,  12

PERCENT, TOP,  45

percent (%) wildcard,  71

performance

aggregates and window functions,  352

ANSI SQL-89 syntax versus ANSI SQL-92 

syntax, 101

asterisk (*)

in column names,  41

in SELECT lists of subqueries,  139

blocking issues,  303

DISTINCT in subqueries,  134

dynamic SQL,  359

multiple references in CTEs,  166

row versioning and isolation levels,  316

sp_executesql, 360

stored procedures,  365

table expressions,  160

UPDATE based on joins,  268

WHERE, 32

window functions,  213

www.it-ebooks.info

---