SQL – Datatype Functions
”;
The Data Type functions in SQL are a scalar functions that returns information about various data type values. Following are the SQL date 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. |
Advertisements
”;