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]

parent, hierarchies  

partial duplicates, importing and  

partial intersections, recipe  

partitioning log-tables recipe  

patterns, statistics  

periods, temporal data   2nd  

       available  

               common  

       calendar information  

       continuous, recipe  

       fully normalized  

       margin and duration  

       margins  

       queries  

               granularity and  

permissions  

       authorization logic, central  

       groups, permission hierarchy  

       individual, changing  

       new  

       permission hierarchy, creating  

       revoking  

       specific, querying  

       status attributes  

       traders, GroupPermissions table  

Pivot tables  

       ASCII chart generation  

       calendar generation and  

       folding data  

       joins  

               rows  

       populating  

       queries, sequencing properties  

        reports  

polling

       client stability  

       triggers and  

POP function  

population, statistics  

precision, granularity (temporal data)  

preventing duplicates  

printing

       arrays  

       calendars  

       matrices  

priority queues  

       implementing  

procedures  

       import procedure, hiding  

       importing and  

       RemoveProjectsRecursive  

ProjectPaths table  

projects, subprojects (children)  

properties

       lists  

       sequencing properties, queries  

pull mechanisms, server push and  

purity index, linear data structure example  

PUSH functions  

 

Категории