O'Reilly logo

Pro T-SQL Programmer’s Guide, 4th Edition by Miguel Cebollero, Jay Natarajan, Michael Coles

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

APPENDIX B

image

XQuery Data Types

SQL Server 2014 supports the data types defined in the XQuery Data Model (XDM). The supported data types are listed with their definitions in Table B-1. The diagram in Figure B-1 is a quick reference showing the relationships between the XDM data types.

9781484201466_Fig21-01.jpg

Figure B-1. XQuery data type system

Table B-1. XQuery Data Types

Type

Description

Base Types

xs:anySimpleType

Base type for all simple built-in types.

xs:anyType

Base type for xs:anySimpleType and complex built-in types.

Date/Time Types

xs:date

Represents a Gregorian ...

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