March 2006
Beginner to intermediate
336 pages
7h 49m
English
Content preview from SQL Server 2005 DistilledBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...