| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Reference Manual Volumes 1 - 4 (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 2 Transact-SQL Functions |
Chapter 2
This chapter describes the Transact-SQL functions. Functions are used to return information from the database. They are allowed in the select list, in the where clause, and anywhere an expression is allowed. They are often used as part of a stored procedure or program.
| Types of functions |
|
| Aggregate functions |
| Aggregates used with group by |
| Aggregate functions and NULL values |
| Vector and scalar aggregates |
| Aggregate functions as row aggregates |
|
| Datatype conversion functions |
| Converting character data to a non-character type |
| Converting from one character type to another |
| Converting numbers to a character type |
| Rounding during conversion to and from money types |
| Converting date/time information |
| Converting between numeric types |
![[+]](/dwicons/i_expand.gif)
| Arithmetic overflow and divide-by-zero errors |
| Conversions between binary and integer types |
| Converting between binary and numeric or decimal types |
| Converting image columns to binary types |
| Converting other types to bit |
| Converting NULL value |
|
| Date functions |
| Date parts |
| Mathematical functions |
| Security functions |
|
| String functions |
| Limits on string functions |
| System functions |
| Text and image functions |
|
| abs |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| acos |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| ascii |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| asin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| atan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| atn2 |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| avg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| ceiling |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| char |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| charindex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| char_length |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| col_length |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| col_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| compare |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| convert |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| cos |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| cot |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| count |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| curunreservedpgs |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| data_pgs |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| datalength |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| dateadd |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| datediff |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| datename |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| datepart |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| db_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| db_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| degrees |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| difference |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| exp |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| floor |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| get_appcontext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| getdate |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| hextoint |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| host_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| host_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| index_col |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| index_colorder |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
|
| inttohex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| isnull |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| is_sec_service_on |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| lct_admin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| license_enabled |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| list_appcontext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| lockscheme |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
|
| log |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| log10 |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| lower |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| ltrim |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| max |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| min |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| mut_excl_roles |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| object_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| object_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| pagesize |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
|
| patindex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| pi |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| power |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| proc_role |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| ptn_data_pgs |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| radians |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| rand |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| replicate |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| reserved_pgs |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| reverse |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| right |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| rm_appcontext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| role_contain |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| role_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| role_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| round |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| rowcnt |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| rtrim |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| set_appcontext |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| show_role |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| show_sec_services |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| sign |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| sin |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| sortkey |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| soundex |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| space |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| sqrt |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| str |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| stuff |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| substring |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| sum |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| suser_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| suser_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| syb_quit() |
| Description |
| Syntax |
| Examples |
| Usage |
| Permissions |
|
| syb_sendmsg |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| tan |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| textptr |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| textvalid |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| to_unichar |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| tsequal |
| Description |
| Syntax |
| Parameters |
| Examples |
|
| Usage |
| Standards |
| Permissions |
| See also |
|
| uhighsurr |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| ulowsurr |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| upper |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| uscalar |
| Description |
| Syntax |
| Parameters |
| Usage |
| Standards |
| Permissions |
| See also |
|
| used_pgs |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| user |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| user_id |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| user_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| valid_name |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
| valid_user |
| Description |
| Syntax |
| Parameters |
| Examples |
| Usage |
| Standards |
| Permissions |
| See also |
|
|