B
System Variables and Functions Reference
Variables and functions are often used interchangeably. SQL Server Books Online documents some variables as if they were functions. However it's important to note that variables return a value whereas functions process specific business logic and many functions accept input arguments. Optional arguments are denoted using square brackets.
System Global Variables
The system-supplied global variables are organized into these categories:
- Configuration
- Cursor
- System
- System Statistics
Configuration
Cursor
System
System Statistical
System Functions
The system functions are organized into these categories:
- Aggregation
- Checksum
- Conversion
- Cursor
- Date
- Image/Text
- Mathematical
- Metadata
- Ranking
- Security
- System
- System Statistics
Aggregation
Checksum
Get Beginning Transact-SQL with SQL Server 2000 and 2005 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.
