SqlServer series notes-common functions
Aggregate functions: MAX (maximum), MIN (minimum), AVG (average), SUM (and), COUNT (quantity)
ABS (): find the absolute value.
CEILING (): rounds to the largest integer. 3.33 will be rounded to 4, 2.89 will be rounded to 3,-3.61 will be rounded to-3.
FLOOR (): rounds to the smallest integer. 3.33 will be rounded to 3, 2.89 will be rounded to 2,-3.61 will be rounded to-4.
ROUND (): rounded. Round to the number closest to my radius.
Round → Radius. Round (3.1425pc.2).
SqlServer2012 iif (expression 1, expression 2, expression 3) returns when expression 1 is True, expression 2 can be nested
ISNULL (expression,value) returns expression if expression is not empty, value otherwise
SELECT ISNULL (FName,' Anonymous') as name FROM
T_Employee
