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]

FIFO (first in, first out) structure  

filters, importing data and  

financial median, statistics  

first and last date of month recipe  

first in, first out (FIFO) structure  

folding

       data

               Pivot tables  

               self-joins  

       tables, importing and  

       union queries  

Foo table, Pivot table population  

full duplicates, importing and  

full intersections, recipe  

fully normalized periods, databases  

functions

       AVG  

       CASE  

       CAST  

       CONVERT  

       COUNT  

       CURRENT_TIMESTAMP   2nd   3rd  

       CURRENT_USER  

       DATEDIFF  

       DATENAME  

       DATEPART  

       GETDATE  

       GETUTCDATE  

       POP  

       PUSH  

       STDEV  

       STDEVP  

       SUM  

       TOP   2nd  

       VAR  

       VARP  

 

Категории