Transact-SQL Cookbook
| [SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W]
Data Manipulation Language (DML) data normalization [See normalized data] data structures linear multidimensional Data Transformation Services (DTS) databases master/detail framework normalized data and periods tables, audit logs and datatypes granularity temporal data 2nd DATETIME 2nd SMALLDATETIME TIMESTAMP date and time input date notation DATEDIFF function DATENAME function DATEPART function DATETIME datatype 2nd durations instants degrees of freedom, statistics DELETE statement lists log triggers row-level logs sets and deleting records, audit log descriptor, audit log records differences, sets NOT EXISTS statement recipe SELECT statement subqueries dissertations, importing example DML (Data Manipulation Language) DTS (Data Transformation Services) duplicates counting occurrences 2nd preventing recipe reduction selective reduction reductions selecting durations, temporal data 2nd calculation recipe calendar information DATETIME datatype reporting, recipe storing dynamic classification system, recipe
|