官术网_书友最值得收藏!

SQL Server data types

The SQL Server Database Engine utilizes a wide selection of data types. A data type is a definition of how a value is structured, stored, and handled. There are data types for any kind of structured, semi-structured, and non-structured type of data.

Structured data types are native SQL Server data types such as int, char, varchar, datetime, binary, varbinary, money, decimal, geography, geometry, location, and so on. Character-based data types support both non-unicode, char/varchar, and unicode, nchar/nvarchar.

Semi-structured data types, such as xml, store their data in a structured manner internally and is usually handled by the database engine as large objects, but at the same time offers flexibility to add custom functions and indexes to efficiently display its content.

Non-structured data types are usually referred to as large objects called blob (binary large objects) or clob (character large objects) and used to store large amounts of data such as documents and binaries in the database. Also, varbinary(max), varchar(max), and nvarchar (max) are seen as non-structured objects. From the 2016 version , SQL Server had used a more modern approach and adequate data types for dealing with non-structured data: polybase feature and support for JSON.

Every data type offers specific features for a specific use. When designing a database, it's important to choose the right data type for every column of a table.

主站蜘蛛池模板: 松原市| 行唐县| 绵阳市| 平远县| 商丘市| 繁峙县| 长宁县| 资溪县| 大理市| 景德镇市| 汝阳县| 涿鹿县| 鲁山县| 仁寿县| 阿拉尔市| 荆州市| 武功县| 泰兴市| 民勤县| 南皮县| 泽库县| 新民市| 苍山县| 曲松县| 呼图壁县| 扎鲁特旗| 岳阳市| 柘荣县| 南通市| 安福县| 光泽县| 瓦房店市| 交城县| 家居| 东丽区| 什邡市| 绩溪县| 白山市| 尖扎县| 扶沟县| 车致|