| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
Transact-SQL User's Guide |
![[-]](/dwicons/i_colpse.gif)
| Chapter 10 Using the Built-In Functions in Queries |
Chapter 10
Built-in functions are a Transact-SQL extension to SQL that return information from the database.
For reference material on the built-in functions, see the Reference Manual.
|
| System functions that return database information |
![[+]](/dwicons/i_expand.gif)
| Examples of using system functions |
|
| String functions used for character strings or expressions |
|
| Examples of using string functions |
|
| Concatenation |
| Nested string functions |
|
| Text functions used for text and image data |
| Readtext |
| Examples of using text functions |
| Aggregate functions |
|
| Mathematical functions |
| Examples of using mathematical functions |
|
| Date functions |
| Get current date: getdate |
| Find date parts as numbers or names |
| Calculate intervals or increment dates |
| Add date interval: dateadd |
|
| Datatype conversion functions |
| Supported conversions |
| Using the general purpose conversion function: convert |
|
| Conversion rules |
|
| Converting binary-like data |
|
| Conversion errors |
| Security functions |
|
|