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. |
Leave a Reply