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
MERGE statement
$action option, 407
dbo.CustomerSource and dbo.CustomerTarget, 408
disadvantage, 406
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.