O'Reilly logo

SQL Server Advanced Data Types: JSON, XML, and Beyond by Peter A. Carter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required