Appendix C. SQL Server Built-In Functions
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. ...
Get SQL Server 2005 Distilled now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
