Date and Time functions
Year, Quarter, Month, Week, Day, DayOfMonth, DayOfYear, DayOfWeek, Hour, Minute, Second, Millisecond
Conversion functions
SN
Math functions
Abs, ASin, ACos, ATan, Atn2, Ceiling, Cos, Sin, Tan, Cot, Exp, Floor, Log, Log10, Power, Sqrt, Square
Operators
+, -, *, /, %
Statistical functions
Sum, Avg, Max, Min, Count, UniqueCount, Count_Big, Stdev, StdevP, Var, VarP
Text functions
Len, Lower, Upper, LTrim, RTrim, Soundex, Reverse
See also:
Details on Microsoft SQL Server Connection