Index

images 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, 409410

MERGE statement

$action option, 407

dbo.CustomerSource and dbo.CustomerTarget, 408

disadvantage, 406

execution code, 407408

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, ...

Get Beginning T-SQL 2012 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.