This section provides an alphabetical listing of Microsoft SQL Server-supported functions, with examples and corresponding results.
Returns the arc cosine of
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 arc sine of
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
resulting value ranges from -/2 to /2 and is expressed in radians.
SELECT ATAN( 3.1415 )-> 1.262619
Returns the angle (in radians) whose tangent is
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: ...