When we assign the column with the data type, the insertion queries work only if the data of the required data type is being inserted else the command fails and exits. Once we study and understand the data to be put in the column, we can decide the data type of the column. When we talk about data types, we need to know about the data that is to be put into the column. Some of the widely used data types in SQL are int, varchar, date object, boolean, etc. In this tutorial, we saw the need and use of data types in SQL. Holds the binary data stored in external files. Holds the universally unique identifiers. Holds large character objects with a max capacity of 2Gb. Holds the two-digit or four-digit value for the variables of type year.ДЇurther classifications of miscellaneous data types are as follows: Sr.No Holds the smaller range of values of date and time both in a single variable. Holds the value of date and time both in a single variable. Stores Unicode variable-length characters with a max capacity of 1 GB characters.ДЇurther classifications of date and time datatype are as follows: Sr.No Stores Unicode variable-length characters with a max capacity of 231 characters. Stores Unicode variable-length characters with a max capacity of 4000 characters. Stores Unicode fixed length characters with a max capacity of 4000 characters. Holds Variable-length non-Unicode data with a max capacity of 2,147,483,647 characters.ДЇurther divisions of Unicode character datatype are as follows: Sr.No Holds Variable-length non-Unicode characters with a max capacity of 231 characters. Holds variable-length non-Unicode characters with a max capacity of 8000 characters. Holds fixed length characters with a maximum capacity of 8000 characters. The divisions of an approximate numeric datatype are as follows: Sr.NoДЇurther classifications of character and string data types are as follows: Sr.No Stores variable-length binary data with a maximum capacity of 2,147,483,647 bytesДЇurther divisions of an exact numeric datatype are as follows: Sr.No Stores variable-length binary data with a maximum capacity of 231 bytes. Stores variable-length binary data with a maximum capacity of 8000 bytes. Stores fixed-length binary data with a maximum capacity of 8000 bytes. However, the sqlmode variable can be set with the REALASFLOAT flag to make REAL a synonym for FLOAT(0-23). Binary DatatypeД«inary datatype has further divisions as follows: Sr.No Some of the data types available in SQL are: 1. Join DataFlair on Telegram!! Available Datatypes Stay updated with latest technology trends

Sql server data types