Because these types align with the SQL Standard and more portable. If you develop a new application, you should use the time, date, datetime2 and datetimeoffset data types. The date and time data types store data and time data, and the date time offset. They are often used in scientific calculations. The approximate numeric data type stores floating point numeric data. The following table illustrates the characteristics of the exact numeric data types: Data Type The money and smallmoney data type store currency values.Note that decimal and numeric are synonyms. The decimal and numeric data types store numbers that have fixed precision and scale.

The int, bigint, smallint, and tinyint data types store integer data.The bit store one of three values 0, 1, and NULL.Exact numeric data typesĮxact numeric data types store exact numbers such as integer, decimal, or monetary amount. Therefore, you should avoid using these data types and use nvarchar(max), varchar(max), and varbinary(max) data types instead. Notice that SQL Server will remove ntext, text, and image data types in its future version. The following picture illustrates the SQL Server data types system: SQL Server provides a list of data types that define all types of data that you can use e.g., defining a column or declaring a variable. It can be an integer, character string, monetary, date and time, and so on. A data type is an attribute that specifies the type of data that these objects can store. In SQL Server, a column, variable, and parameter holds a value that associated with a type, or also known as a data type. Summary: in this tutorial, you will learn about SQL Server data types including numeric, character string, binary string, date & time, and other data types.

Sql redshift data types