To learn more about SQL data types, read “SQL basics: String data types,” which covers general data-type usage and describes using the various string data types, and “SQL basics: Number data ...

JSON data is stored as plain text and isn't considered a special type, such as XML and Spatial. However, this just enables you to use JSON columns in any SQL Server objects right away. The same can't ...