Transact-SQL Desk Reference

2.6. TRANSACT-SQL FUNCTIONS

Microsoft SQL Server 2000 has a large number of built-in functions available for SQL programming, database administration and other purposes. The major categories are listed in Table 2-51.

The following sections contain detailed explanations for each of the categories from Table 2-51, categorizing the functions and describing their general purpose. Some of the commonly used functions are covered in greater detail, with examples. All functions can be found in Books Online.

Table 2-51. Built-in Functions

Function Category	Description
Aggregate Functions	Perform a calculation on a set of values and return a single summarizing value, e.g., COUNT(), SUM(), AVG()
Cursor Functions	Returns information about cursors.
Configuration ...