Index[A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] FLOAT data type FLOOR function foreign keys referential integrity constraints formats FROM, SELECT statement FULL OUTER JOIN functions ABS aggregate functions AVG 2nd COUNT 2nd 3rd MAX MIN SUM 2nd ASC CEILING conversion CAST CONVERT 2nd STR date functions DATEADD 2nd DATEDIFF 2nd DATEPART 2nd DAY 2nd GETDATE 2nd MONTH YEAR 2nd DATEFORMAT DESC FLOOR LIKE numeric row-level functions arithmetic operations on columns DISTINCT 2nd IS NOT NULL IS NULL ISNULL NULLIF 2nd ROUND 2nd TOP 2nd 3rd ROWCOUNT 2nd SET DATEFORMAT SORT SQUARE STR string functions CHARINDEX 2nd concatenation extraction LEFT 2nd LEN LOWER LTRIM RIGHT 2nd RTRIM 2nd SUBSTRING 2nd UPPER 2nd |