Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the different data types available in SQL Server?

April 26, 2017Data different SQL Server types

0

Posted

What are the different data types available in SQL Server?

1 Answer

0

Posted

Numeric: Stores numeric values. Monetary: It stores numeric values with decimal places. It is used specially for currency values. Data and Time: It stores date and time information. Character: It supports character based values of varying lengths. Binary: It stores data in strict binary (0 or 1) Representation. Special purpose: SQL Server contains Complex data types to handle the XML Documents, Globally unique identifiers etc. What are the specialized data types in SQL Server? bit :Stores a 0, 1, or null. Used for basic “flag” values. TRUE is converted to 1, and FALSE is converted to 0. Timestamp: An automatically generated value. Each database contains an internal counter that designates a relative time counter not associated with an actual clock. A table can have only one time stamp column, which is set to the database timestamp when the row is inserted or modified. Uniqueidentifier: A 16-bit GUID used to globally identify a row across databases, instances, and servers. sql_variant: