Data types in SQL Server are organized into the following categories:
Exact numerics. Unicode character strings.
Approximate numerics. Binary strings.
Date and time. Other data types.
Integral, Floating Point, Character, Character String, and Composite types are the five basic data types recognised by most current computer languages, with several specialised subtypes defined within each broad category.
A data type is a property that describes the type of data that these objects can store. It could be a number, a character string, a monetary value, a date and time, or something else entirely. SQL Server provides a list of data types that specify all sorts of data that can be used in SQL Server, such as when defining a column or declaring a variable.
The format of data storage that may hold a specific type or range of values is referred to as database data types. When data is stored in variables in computer programmes, each variable must have its own data type. Integers, characters, strings, floating-point numbers, and arrays are some of the most popular data types.
Nominal, ordinal, discrete, and continuous data are the four types of data.