5 Appendix A: Product Behavior
The information in this specification is applicable to the following Microsoft products or supplemental software. References to product versions include updates to those products.
Microsoft SQL Server 2008 R2
Microsoft SQL Server 2012
Microsoft SQL Server 2014
Microsoft SQL Server 2016
Microsoft SQL Server 2017
Microsoft SQL Server 2019
Microsoft SQL Server 2022
Exceptions, if any, are noted in this section. If an update version, service pack or Knowledge Base (KB) number appears with a product name, the behavior changed in that update. The new behavior also applies to subsequent updates unless otherwise specified. If a product edition appears with the product version, behavior is different in that product edition.
Unless otherwise specified, any statement of optional behavior in this specification that is prescribed using the terms "SHOULD" or "SHOULD NOT" implies product behavior in accordance with the SHOULD or SHOULD NOT prescription. Unless otherwise specified, the term "MAY" implies that the product does not follow the prescription.
<1> Section 1.6: The following table lists versions of the serialization format for GEOGRAPHY and GEOMETRY structures and the products to which those versions apply.
|
Serialization format |
Applicable product |
|---|---|
|
Version 1 |
|
|
Version 2 |
|
<2> Section 2.1: Microsoft SQL Server supports four building elements, except for SQL Server 2008 R2, which supports three building elements.
<3> Section 2.1.1: In Microsoft implementations, a value set to 1 denotes version 1 of the structure and a value set to 2 denotes version 2 of the structure.
<4> Section 2.1.2: In Microsoft implementations, a value set to 1 denotes version 1 of the structure and a value set to 2 denotes version 2 of the structure.
<5> Section 2.2.1: Microsoft implementations do not produce values outside the range 00:00:00.0000000 through 23:59:59.9999999 but will accept values outside the range as described in [MS-BINXML] section 2.4.2.