Index
A
Advanced data types
GEOGRAPHY
GEOMETRY
HIERARCHYID
JSON
XML
Aggregation methods
B
Bill of materials (BoM)
Binary data types
BINARY
CONVERT function
converting to character string
encrypted password
IMAGE
style options
VARBINARY
C
CAST function
Character data types
CHAR
NCHAR
NTEXT
NVARCHAR
string storage sizes
TEXT
VARCHAR
Clustered indexes
creating
description
inserts
primary key
tables
B-Tree structure
heap structure
updates
Common table expression (CTE)
Configuration management database (CMDB)
CONVERT function
D
Date and time data types
casting
DATE
DATETIME
DATETIME2
DATETIMEOFFSET
details
SMALLDATETIME
style options
TIME
Document type definition (DTD)
E
exist() method
Extensible Markup Language (XML)
attribute-centric approach
aspect of
generating
sales orders
definition
element-centric approach ...
Get SQL Server Advanced Data Types: JSON, XML, and Beyond now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
