O'Reilly logo

Beginning Transact-SQL with SQL Server 2000 and 2005 by Dan Wood, Paul Turley

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

images

images

images

Cursor

images

System

images

System Statistical

images

images

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required