114 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
1DATELENGTH()

Returns the number of bytes used to represent any expression and also counts the leading and trailing spaces of the expression.

2IDENT_CURRENT()

Returns the last identity value generated for a specified table or view on an identity column.

3IDENT_INCR()

Returns the increment value of the identity column.

4IDENT_SEED()

Returns the original seed value.

5SQL_VARIANT_PROPERTY()

Returns the base data types and other information about a sql_variant value.

Comments

Post a Comment

Popular posts from this blog

79 HTML - Tables

Image
HTML tables   represent data, such as text, images, etc. in a structured format with rows and columns. HTML tables  offer a visual structure that aids in clarity and comprehension, making them a fundamental element in web development. Why HTML Tables are Used? HTML tables are used for various reasons, primarily centered around organizing and presenting data effectively. Some key purposes include − Structuring Data  − Tables provide a coherent structure for organizing and displaying data, making it easier for users to interpret information. Comparative Presentation  − When there is a need to compare different sets of data side by side like difference between two concepts, tables offer a clear and visually accessible format. Tabular Data Representation  − Information that naturally fits into rows and columns, such as schedules, statistics, or pricing tables, can be well-represented using HTML tables. Creating an HTML Table You can create a table in HTML by using t...
Read more