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