SQL in a Nutshell

SQL Server-Supported Functions

This section provides an alphabetical listing of Microsoft SQL Server-supported functions, with examples and corresponding results.

ACOS( number )

Returns the arc cosine of number ranging from -1 to 1. The result ranges from 0 to and is expressed in radians. For example:

SELECT ACOS( 0 ) -> 1.570796

APP_NAME( )

Returns the application name for the current session, set by the application. For example:

SELECT APP_NAME( ) -> 'SQL Enterprise Manager'

ASCII( text )

Returns the ASCII code of the first character of text. For example:

SELECT ASCII('x') -> 120

ASIN( number )

Returns the arc sine of number ranging from -1 to 1. The resulting value ranges from -/2 to /2 and is expressed in radians. For example:

SELECT ASIN( 0 ) -> 0.000000

ATAN( number )

Returns the arctangent of any number. The resulting value ranges from -/2 to /2 and is expressed in radians. For example:

SELECT ATAN( 3.1415 ) -> 1.262619

ATN2( float1, float2 )

Returns the angle (in radians) whose tangent is float1/float2. For example:

SELECT ATN2( 35.175643, 129.44 ) -> 0.265345

BINARY_CHECKSUM( * | expression [,...n])

Returns the binary checksum for a list of expressions or for a row of a table. This example returns a list of user IDs where the stored password checksum doesn't match the current password's checksum:

SELECT userid AS 'Changed' FROM users WHERE NOT password_chksum = 
BINARY_CHECKSUM( password )

CHAR( integer_expression )

Converts a numeric ASCII code to a character. For example: ...