SQL Server Advanced Data Types: JSON, XML, and Beyond

© Peter A. Carter  2018

Peter A. CarterSQL Server Advanced Data Typeshttps://doi.org/10.1007/978-1-4842-3901-8_1

1. SQL Server Data Types

Peter A. Carter¹ 

(1)

London, UK

 

SQL Server 2017 provides a wide range of basic data types that can store data, such as character strings, numeric data, binary data, and dates. In this chapter, I will review each of the basic data types available in SQL Server, looking at the differences between similar data types. I will also discuss the importance of using the correct data type for each use case.

Tip

The following sections discuss the acceptable ranges for each data type. It is worth noting, however, that all data types can also be set to NULL, indicating that the value is unknown.

Numeric Data Types

Some numeric ...