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]
calendar information durations periods calendars Pivot table and printing Cartesian products, Pivot tables CASE function CASE statement SUM function and case, statistics CAST function children, hierarchies locating immediate subprojects classes aggregated, summarizing sets, summarizing classification system, dynamic (recipe) columns , nonaggregated comparisons recipe complements, sets recipes different universe finding missing size components of sets confidence intervals, statistics building, recipe calculations degrees of freedom t-distribution table contains operation continuous periods, recipe CONVERT clause, granularity CONVERT function correlation coefficient, statistics correlation, statistics calculating, recipe COUNT function counting duplicates 2nd cross-sectional data, statistics cumulative aggregates, lists cumulative aggregation queries, lists CURRENT_TIMESTAMP function 2nd 3rd CURRENT_USER function cursors global procedures
|