Sql 简明教程

SQL - Datatype Functions

SQL 中的数据类型函数是一个标量函数，它返回有关各种数据类型值的信息。以下是 SQL 日期类型函数 -

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.