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