Beginning T-SQL 2012

Index

A

ABS function, 108

$action option, 407

ad hoc DELETE statements, 218

admin function, 116

Advanced queries, 391

CTE (see Common table expressions (CTEs))

database cleanup, 417

GROUPING SETS, 409–410

MERGE statement

$action option, 407

dbo.CustomerSource and dbo.CustomerTarget, 408

disadvantage, 406

execution code, 407–408

FirstName, MiddleName, and LastName columns, 408

results, 409

syntax, 406

target table, 406

UPDATE, INSERT, and DELETE statement, 406

numbers table

calendar table, 415

comma-delimited list parsing, 416

data management, 416

primary key constraint, 414

sequential list of numbers, 414

table creation, 414

tblNumbers populating, ...