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]
t-distribution table confidence intervals and table joins, Pivot table rows tables [See also Pivot tables] AccountPermissions arrays, joining audit logs and duplicates empty rows, defining EventLogMaster GroupPermissions normalizing importing, folding tables locking log tables global partitioning recipe structure logs snapshots undoing changes master records, extracting master table non-normalized, master records and normalized data dependent columns repeating columns and Pivot tables, reports ProjectPaths t-distribution TABLOCK tasks subtasks vertices, expensive temporal data datatypes 2nd date input date notation durations 2nd calculation recipe reporting recipe storing first and last date of month recipe granularity CONVERT clause precision rules enforcement recipe INSERT statement instants functions out-of-range values, storing overview periods 2nd querying schedules example trap types three-dimensional arrays ticketing, server push time-series data, statistics TIMESTAMP datatype TOP function 2nd TOP keyword SELECT TOP statement traces, matrices traders, GroupPermissions table transposing matrices TraversProjectsRecursive stored procedure trees, hierarchies nodes child leaf node listing parent root subtrees traversing, recursive algorithm vertex triggers audit logs INSERT, master records online logs polling as alternative UPDATE validation processing two-dimensional arrays
|