English 中文(简体)
SQL Tutorial

5. 图瓦卢

Selected Reading

SQL - Datatype Functions
  • 时间:2024-09-17

SQL - Datatype Functions


Previous Page Next Page  

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 traipng 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