This section provides an alphabetical listing of Microsoft SQL Server-supported functions, with examples and corresponding results.
Returns the arccosine 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
Returns the application name for the current session, set by the application. For example:
SELECT APP_NAME( )-> 'SQL Enterprise Manager'
Returns the ASCII code of the first character of
text. For example:
SELECT ASCII('x')-> 120
Returns the arcsine 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
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
Returns the angle (in radians) whose tangent is
float2. For example:
SELECT ATN2( 35.175643, 129.44 )-> 0.265345
expression[, . . .
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 )
Converts a numeric ASCII code to a character. For example:
SELECT CHAR( 78 )-> 'N' ...