Transact SQL Functions
|
| Tipo de Función Type of Function |
Descripción Description |
|---|---|
Aggregate |
Generate summary values that appear as new columns in the query results |
Datatype Conversion |
Change expressions from one datatype to another and specify new display formats for date/time information |
Date |
Do computations on datetime and smalldatetime values and their components, date parts |
Mathematical |
Return values commonly needed for operations on mathematical data |
Row Aggregate |
Generat summary values that appear as additional rows in the query results |
String |
Operate on binary dat, character strings, and expressions |
System |
Return special information from the databse |
text/image |
Supply values commonly needed for operations on text and image data |