Book description
- Understand the implementation of basic data types and why using the correct type is so important
- Work with XML data through the XML data type
- Construct XML data from relational result sets
- Store and manipulate JSON data using the JSON data type
- Model and analyze spatial data for geographic information systems
- Define hierarchies and query them efficiently through the HierarchyID type
Table of contents
- Cover
- Front Matter
- 1. SQL Server Data Types
- 2. Understanding XML
- 3. Constructing XML with T-SQL
- 4. Querying and Shredding XML
- 5. XML Indexes
- 6. Understanding JSON
- 7. Constructing JSON from T-SQL
- 8. Shredding JSON Data
- 9. Working with the JSON Data Type
- 10. Understanding Spatial Data
- 11. Working with Spatial Data
- 12. Working with Hierarchical Data and HierarchyID
- Back Matter
Product information
- Title: SQL Server Advanced Data Types: JSON, XML, and Beyond
- Author(s):
- Release date: August 2018
- Publisher(s): Apress
- ISBN: 9781484239018
You might also like
book
XML and JSON Recipes for SQL Server: A Problem-Solution Approach
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that …
book
SQL Server Data Automation Through Frameworks: Building Metadata-Driven Frameworks with T-SQL, SSIS, and Azure Data Factory
Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server …
book
Building Custom Tasks for SQL Server Integration Services: The Power of .NET for ETL for SQL Server 2019 and Beyond
Build custom SQL Server Integration Services (SSIS) tasks using Visual Studio Community Edition and C#. Bring …
book
Microsoft SQL Server 2014 Unleashed
The industry’s most complete, useful, and up-to-date guide to SQL Server 2014. You’ll find start-to-finish coverage …