The Data Type functions in SQL are scalar functions that return information about various data type values. These functions are very useful when working with identity columns and variable data types. Below is the list of available SQL Data Type functions:
| Sr.No. | Function | Description |
|---|---|---|
| 1 | DATELENGTH() |
Returns the number of bytes used to represent any expression and also counts the leading and trailing spaces of the expression. |
| 2 | IDENT_CURRENT() |
Returns the last identity value generated for a specified table or view on an identity column. |
| 3 | IDENT_INCR() |
Returns the increment value of the identity column. |
| 4 | IDENT_SEED() |
Returns the original seed value. |
| 5 | SQL_VARIANT_PROPERTY() |
Returns the base data types and other information about a sql_variant value. |