SQLMI data type sup except Data Type precedence

niko-neugebauer · niko-neugebauer · commit 218fc79a1f84 · 2021-07-27T14:30:22.000+01:00
diff --git a/docs/includes/tsql-appliesto-ss2012-all-md.md b/docs/includes/tsql-appliesto-ss2012-all-md.md
@@ -6,4 +6,4 @@ ms.date: 01/13/2020
 ms.author: mikeray
 ---
 
-<Token>**APPLIES TO:** :::image type="icon" source="media/yes-icon.png":::SQL Server :::image type="icon" source="media/yes-icon.png":::Azure SQL Database :::image type="icon" source="media/yes-icon.png":::Azure Synapse Analytics :::image type="icon" source="media/yes-icon.png":::Parallel Data Warehouse </Token>
+<Token>**APPLIES TO:** :::image type="icon" source="media/yes-icon.png":::SQL Server :::image type="icon" source="media/yes-icon.png":::Azure SQL Database :::image type="icon" source="media/yes-icon.png":::Azure SQL Managed Instance :::image type="icon" source="media/yes-icon.png":::Azure Synapse Analytics :::image type="icon" source="media/yes-icon.png":::Parallel Data Warehouse </Token>
diff --git a/docs/t-sql/data-types/cursor-transact-sql.md b/docs/t-sql/data-types/cursor-transact-sql.md
@@ -17,7 +17,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # cursor (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 A data type for variables or stored procedure OUTPUT parameters that contain a reference to a cursor.
   
diff --git a/docs/t-sql/data-types/data-type-synonyms-transact-sql.md b/docs/t-sql/data-types/data-type-synonyms-transact-sql.md
@@ -19,7 +19,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Data type synonyms (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Data type synonyms are included in [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] for ISO compatibility. The following table lists the synonyms and the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] system data types that they map to.
   
diff --git a/docs/t-sql/data-types/date-and-time-types.md b/docs/t-sql/data-types/date-and-time-types.md
@@ -15,7 +15,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Date and time types
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
 
 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports the following date and time types.
   
diff --git a/docs/t-sql/data-types/getancestor-database-engine.md b/docs/t-sql/data-types/getancestor-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # GetAncestor (Database Engine)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns a **hierarchyid** representing the *n*th ancestor of *this*.
   
diff --git a/docs/t-sql/data-types/getdescendant-database-engine.md b/docs/t-sql/data-types/getdescendant-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # GetDescendant (Database Engine)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns a child node of the parent.
   
diff --git a/docs/t-sql/data-types/getlevel-database-engine.md b/docs/t-sql/data-types/getlevel-database-engine.md
@@ -22,7 +22,7 @@ ms.author: mikeray
 
 # GetLevel (Database Engine)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns an integer that represents the depth of the node *this* in the tree.
   
diff --git a/docs/t-sql/data-types/getreparentedvalue-database-engine.md b/docs/t-sql/data-types/getreparentedvalue-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # GetReparentedValue (Database Engine)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns a node whose path from the root is the path to _newRoot_, followed by the path from _oldRoot_.
   
diff --git a/docs/t-sql/data-types/getroot-database-engine.md b/docs/t-sql/data-types/getroot-database-engine.md
@@ -22,7 +22,7 @@ ms.author: mikeray
 
 # GetRoot (Database Engine)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns the root of the hierarchy tree. GetRoot() is a static method.
   
diff --git a/docs/t-sql/data-types/hierarchyid-data-type-method-reference.md b/docs/t-sql/data-types/hierarchyid-data-type-method-reference.md
@@ -21,7 +21,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # hierarchyid data type method reference
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 The **hierarchyid** data type is a variable length, system data type. Use **hierarchyid** to represent position in a hierarchy. A column of type **hierarchyid** does not automatically represent a tree. It is up to the application to generate and assign **hierarchyid** values in such a way that the desired relationship between rows is reflected in the values.
   
diff --git a/docs/t-sql/data-types/isdescendantof-database-engine.md b/docs/t-sql/data-types/isdescendantof-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # IsDescendantOf (Database Engine)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns true if *this* is a descendant of parent.
   
diff --git a/docs/t-sql/data-types/nondeterministic-convert-date-literals.md b/docs/t-sql/data-types/nondeterministic-convert-date-literals.md
@@ -15,6 +15,7 @@ ms.reviewer: "genemi"
 monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Nondeterministic conversion of literal date strings into DATE values
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Use caution when allowing conversion of your CHARACTER strings into DATE data types. The reason is that such conversions are often _nondeterministic_.
 
diff --git a/docs/t-sql/data-types/ntext-text-and-image-transact-sql.md b/docs/t-sql/data-types/ntext-text-and-image-transact-sql.md
@@ -24,7 +24,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # ntext, text, and image (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Fixed and variable-length data types for storing large non-Unicode and Unicode character and binary data. Unicode data uses the UNICODE UCS-2 character set.
   
diff --git a/docs/t-sql/data-types/parse-database-engine.md b/docs/t-sql/data-types/parse-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Parse (Database Engine)
-[!INCLUDE [SQL Server Azure SQL Database ](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Parse converts the canonical string representation of a **hierarchyid** to a **hierarchyid** value. Parse is called implicitly when a conversion from a string type to **hierarchyid** occurs. Acts as the opposite of [ToString](../../t-sql/data-types/tostring-database-engine.md). Parse() is a static method.
   
diff --git a/docs/t-sql/data-types/precision-scale-and-length-transact-sql.md b/docs/t-sql/data-types/precision-scale-and-length-transact-sql.md
@@ -24,7 +24,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Precision, scale, and Length (Transact-SQL)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Precision is the number of digits in a number. Scale is the number of digits to the right of the decimal point in a number. For example, the number 123.45 has a precision of 5 and a scale of 2.
   
diff --git a/docs/t-sql/data-types/read-database-engine.md b/docs/t-sql/data-types/read-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Read (Database Engine) by using CSharp
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Read reads binary representation of **SqlHierarchyId** from the passed-in **BinaryReader** and sets the **SqlHierarchyId** object to that value. Read cannot be called by using [!INCLUDE[tsql](../../includes/tsql-md.md)]. Use CAST or CONVERT instead.
   
diff --git a/docs/t-sql/data-types/rowversion-transact-sql.md b/docs/t-sql/data-types/rowversion-transact-sql.md
@@ -29,7 +29,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # rowversion (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Is a data type that exposes automatically generated, unique binary numbers within a database. **rowversion** is generally used as a mechanism for version-stamping table rows. The storage size is 8 bytes. The **rowversion** data type is just an incrementing number and does not preserve a date or a time. To record a date or time, use a **datetime2** data type.
   
diff --git a/docs/t-sql/data-types/sql-variant-transact-sql.md b/docs/t-sql/data-types/sql-variant-transact-sql.md
@@ -25,7 +25,7 @@ ms.author: mikeray
 
 # sql_variant (Transact-SQL)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 A data type that stores values of various [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)]-supported data types.
   
diff --git a/docs/t-sql/data-types/string-and-binary-types.md b/docs/t-sql/data-types/string-and-binary-types.md
@@ -18,7 +18,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # String and Binary Types
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] supports the following string and binary types.
   
diff --git a/docs/t-sql/data-types/table-transact-sql.md b/docs/t-sql/data-types/table-transact-sql.md
@@ -18,7 +18,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # table (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Is a special data type used to store a result set for processing at a later time. **table** is primarily used for temporarily storing a set of rows that are returned as the table-valued function result set. Functions and variables can be declared to be of type **table**. **table** variables can be used in functions, stored procedures, and batches. To declare variables of type **table**, use [DECLARE @local_variable](../../t-sql/language-elements/declare-local-variable-transact-sql.md).
   
diff --git a/docs/t-sql/data-types/tostring-database-engine.md b/docs/t-sql/data-types/tostring-database-engine.md
@@ -22,7 +22,7 @@ ms.author: mikeray
 
 # ToString (Database Engine)
 
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Returns a string with the logical representation of *this*. ToString is called implicitly when a conversion from **hierarchyid** to a string type occurs. Acts as the opposite of [Parse &#40;Database Engine&#41;](../../t-sql/data-types/parse-database-engine.md).
   
diff --git a/docs/t-sql/data-types/write-database-engine.md b/docs/t-sql/data-types/write-database-engine.md
@@ -20,7 +20,7 @@ author: MikeRayMSFT
 ms.author: mikeray
 ---
 # Write (Database Engine)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Write writes out a binary representation of **SqlHierarchyId** to the passed-in **BinaryWriter**. Write cannot be called by using [!INCLUDE[tsql](../../includes/tsql-md.md)]. Use CAST or CONVERT instead.
   
diff --git a/docs/t-sql/xml/binding-relational-data-inside-xml-data.md b/docs/t-sql/xml/binding-relational-data-inside-xml-data.md
@@ -21,7 +21,7 @@ author: rothja
 ms.author: jroth
 ---
 # Binding Relational Data Inside XML Data
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   You can specify [xml Data Type Methods](../../t-sql/xml/xml-data-type-methods.md) against an **xml** data type variable or column. For example, the [query&#40;&#41; Method &#40;xml Data Type&#41;](../../t-sql/xml/query-method-xml-data-type.md) executes the specified XQuery against an XML instance. When you construct XML in this manner, you may want to bring in a value from a non-XML type column or a Transact-SQL variable. This process is referred to as binding relational data inside XML.  
   
diff --git a/docs/t-sql/xml/delete-xml-dml.md b/docs/t-sql/xml/delete-xml-dml.md
@@ -19,7 +19,7 @@ author: rothja
 ms.author: jroth
 ---
 # delete (XML DML)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Deletes nodes from an XML instance.  
   
diff --git a/docs/t-sql/xml/exist-method-xml-data-type.md b/docs/t-sql/xml/exist-method-xml-data-type.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # exist() Method (xml Data Type)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Returns a **bit** that represents one of the following conditions:  
   
diff --git a/docs/t-sql/xml/guidelines-for-using-xml-data-type-methods.md b/docs/t-sql/xml/guidelines-for-using-xml-data-type-methods.md
@@ -19,7 +19,7 @@ ms.author: jroth
 
 # Guidelines for Using xml Data Type Methods
 
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 This topic describes guidelines for using the **xml** data type methods.
 
diff --git a/docs/t-sql/xml/insert-xml-dml.md b/docs/t-sql/xml/insert-xml-dml.md
@@ -19,7 +19,7 @@ author: rothja
 ms.author: jroth
 ---
 # insert (XML DML)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Inserts one or more nodes identified by *Expression1* as child nodes or siblings of the node identified by *Expression2*.  
   
diff --git a/docs/t-sql/xml/modify-method-xml-data-type.md b/docs/t-sql/xml/modify-method-xml-data-type.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # modify() Method (xml Data Type)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Modifies the contents of an XML document. Use this method to modify the content of an **xml** type variable or column. This method takes an XML DML statement to insert, update, or delete nodes from XML data. The **modify()** method of the **xml** data type can only be used in the SET clause of an UPDATE statement.  
   
diff --git a/docs/t-sql/xml/nodes-method-xml-data-type.md b/docs/t-sql/xml/nodes-method-xml-data-type.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # nodes() Method (xml Data Type)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 The **nodes()** method is useful when you want to shred an **xml** data type instance into relational data. It allows you to identify nodes that will be mapped into a new row.  
   
diff --git a/docs/t-sql/xml/query-method-xml-data-type.md b/docs/t-sql/xml/query-method-xml-data-type.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # query() Method (xml Data Type)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Specifies an XQuery against an instance of the **xml** data type. The result is of **xml** type. The method returns an instance of untyped XML.  
   
diff --git a/docs/t-sql/xml/replace-value-of-xml-dml.md b/docs/t-sql/xml/replace-value-of-xml-dml.md
@@ -20,7 +20,7 @@ author: rothja
 ms.author: jroth
 ---
 # replace value of (XML DML)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
 Updates the value of a node in the document.  
   
diff --git a/docs/t-sql/xml/value-method-xml-data-type.md b/docs/t-sql/xml/value-method-xml-data-type.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # value() Method (xml Data Type)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Performs an XQuery against the XML and returns a value of SQL type. This method returns a scalar value.  
   
diff --git a/docs/t-sql/xml/with-xmlnamespaces.md b/docs/t-sql/xml/with-xmlnamespaces.md
@@ -23,7 +23,7 @@ author: rothja
 ms.author: jroth
 ---
 # WITH XMLNAMESPACES
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Declares one or more XML namespaces.  
   
diff --git a/docs/t-sql/xml/xml-data-modification-language-xml-dml.md b/docs/t-sql/xml/xml-data-modification-language-xml-dml.md
@@ -23,7 +23,7 @@ author: rothja
 ms.author: jroth
 ---
 # XML Data Modification Language (XML DML)
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   The XML Data Modification Language (XML DML) is an extension of the XQuery language. As defined by W3C, the XQuery language lacks the Data Manipulation (DML) part. The XML DML introduced in this topic, and also the XQuery language, provides a fully functional query and data-modification language that you can use against the **xml** data type.  
   
diff --git a/docs/t-sql/xml/xml-data-type-methods.md b/docs/t-sql/xml/xml-data-type-methods.md
@@ -17,7 +17,7 @@ author: rothja
 ms.author: jroth
 ---
 # xml Data Type Methods
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   You can use the **xml** data type methods to query an XML instance stored in a variable or column of **xml** type. The topics in this section describe how to use the **xml** data type methods.  
   
diff --git a/docs/t-sql/xml/xml-schema-namespace.md b/docs/t-sql/xml/xml-schema-namespace.md
@@ -23,7 +23,7 @@ author: rothja
 ms.author: jroth
 ---
 # xml_schema_namespace
-[!INCLUDE [SQL Server](../../includes/applies-to-version/sqlserver.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Reconstructs all the schemas or a specific schema in the specified XML schema collection. This function returns an **xml** data type instance.  
   
diff --git a/docs/t-sql/xml/xml-transact-sql.md b/docs/t-sql/xml/xml-transact-sql.md
@@ -21,7 +21,7 @@ ms.date: "07/26/2017"
 ---
 
 # xml (Transact-SQL)
-[!INCLUDE [SQL Server SQL Database](../../includes/applies-to-version/sql-asdb.md)]
+[!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
 
   Is the data type that stores XML data. You can store **xml** instances in a column, or a variable of **xml** type.  
   
