The following two tables represent the most commonly used functions with Transact-SQL batches. This listing is not exhaustive, and you should consult SQL Server Books Online for complete information by reviewing the topic titled “functions.”
User defined functions can be queried via the sys.objects_all catalog view.
Table C-1. Aggregate Functions
Table C-2. String Functions Available in SQL Server 2005*
* There haven’t been any changes in these since SQL Server 2000.
TEXTPTR and TEXTVALID are deprecated. ...