fixes moniker and applies to to match for Azure Synapse

julieMSFT · julieMSFT · commit 530187d45aeb · 2021-08-16T10:30:35.000-07:00
diff --git a/docs/includes/applies-to-version/sql-asdbmi-asa-svrless-poolonly.md b/docs/includes/applies-to-version/sql-asdbmi-asa-svrless-poolonly.md
@@ -0,0 +1,9 @@
+---
+author: MikeRayMSFT
+ms.service: sql
+ms.topic: include
+ms.date: 06/11/2020
+ms.author: mikeray
+---
+
+[!INCLUDE [Applies to](../../includes/applies-md.md)] [!INCLUDE [SQL Server](_ssnoversion.md)] [!INCLUDE [ASDBMI](_asdbmi.md)]  [!INCLUDE [Azure Synapse Analytics (serverless SQL pool only)](../../includes/applies-to-version/_asa-svrless-sqlpool-only.md)]  
diff --git a/docs/t-sql/data-types/data-type-precedence-transact-sql.md b/docs/t-sql/data-types/data-type-precedence-transact-sql.md
@@ -19,6 +19,8 @@ helpviewer_keywords:
 ms.assetid: f4c804ab-ed3f-43b1-a024-c9ac6944b66b
 author: MikeRayMSFT
 ms.author: mikeray
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
+
 ---
 # Data type precedence (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
diff --git a/docs/t-sql/data-types/date-and-time-types.md b/docs/t-sql/data-types/date-and-time-types.md
@@ -13,6 +13,7 @@ dev_langs:
 ms.assetid: 100d5670-e2d8-425c-a927-2b4dfe453e28
 author: MikeRayMSFT
 ms.author: mikeray
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # Date and time types
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
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,7 +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)]
+[!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.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/functions/compress-transact-sql.md b/docs/t-sql/functions/compress-transact-sql.md
@@ -16,6 +16,7 @@ helpviewer_keywords:
 ms.assetid: c2bfe9b8-57a4-48b4-b028-e1a3ed5ece88
 author: cawrites
 ms.author: chadam
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # COMPRESS (Transact-SQL)
 [!INCLUDE [sqlserver2016-asdb-asdbmi-asa](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/functions/database-principal-id-transact-sql.md b/docs/t-sql/functions/database-principal-id-transact-sql.md
@@ -21,6 +21,7 @@ helpviewer_keywords:
 ms.assetid: 908c7dd8-c10b-4658-92f6-0224f9835dd9
 author: VanMSFT
 ms.author: vanto
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # DATABASE_PRINCIPAL_ID (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/functions/decompress-transact-sql.md b/docs/t-sql/functions/decompress-transact-sql.md
@@ -16,6 +16,7 @@ helpviewer_keywords:
 ms.assetid: 738d56be-3870-4774-b112-3dce27becc11
 author: cawrites
 ms.author: chadam
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # DECOMPRESS (Transact-SQL)
 [!INCLUDE [sqlserver2016-asdb-asdbmi-asa](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa.md)]
@@ -43,14 +44,20 @@ A value of data type **varbinary(max)**. `DECOMPRESS` will use the ZIP algorithm
   
 ### A. Decompress Data at Query Time  
 This example shows how to return compressed table data:  
+
+
   
 ```sql  
 SELECT _id, name, surname, datemodified,  
              CAST(DECOMPRESS(info) AS NVARCHAR(MAX)) AS info  
 FROM player;  
 ```  
   
-### B. Display Compressed Data Using Computed Column  
+### B. Display Compressed Data Using Computed Column
+
+> [!NOTE]
+> This example does not apply to Azure Synapse Analytics.
+
 This example shows how to create a table for decompressed data storage:  
   
 ```sql  
diff --git a/docs/t-sql/functions/grouping-transact-sql.md b/docs/t-sql/functions/grouping-transact-sql.md
@@ -23,6 +23,7 @@ helpviewer_keywords:
 ms.assetid: 4efa3868-1fc4-4626-8fb1-e863cc03e422
 author: cawrites
 ms.author: chadam
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # GROUPING (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/functions/logical-functions-greatest-transact-sql.md b/docs/t-sql/functions/logical-functions-greatest-transact-sql.md
@@ -17,6 +17,7 @@ helpviewer_keywords:
 author: jmsteen
 ms.author: josteen
 ms.reviewer: wiassaf
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # Logical Functions - GREATEST (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-svrless-poolonly](../../includes/applies-to-version/sql-asdb-asdbmi-asa-svrless-poolonly.md)]
diff --git a/docs/t-sql/functions/logical-functions-least-transact-sql.md b/docs/t-sql/functions/logical-functions-least-transact-sql.md
@@ -17,6 +17,7 @@ helpviewer_keywords:
 author: jmsteen
 ms.author: josteen
 ms.reviewer: wiassaf
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # Logical Functions - LEAST (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-svrless-poolonly](../../includes/applies-to-version/sql-asdb-asdbmi-asa-svrless-poolonly.md)]
diff --git a/docs/t-sql/functions/mathematical-functions-transact-sql.md b/docs/t-sql/functions/mathematical-functions-transact-sql.md
@@ -17,6 +17,7 @@ helpviewer_keywords:
 ms.assetid: 46495a2e-81d0-4677-9d72-9db083cd1023
 author: cawrites
 ms.author: chadam
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest || >=aps-pdw-2016"
 ---
 # Mathematical Functions (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
diff --git a/docs/t-sql/functions/object-schema-name-transact-sql.md b/docs/t-sql/functions/object-schema-name-transact-sql.md
@@ -22,6 +22,7 @@ helpviewer_keywords:
 ms.assetid: 5ba90bb9-d045-4164-963e-e9e96c0b1e8b
 author: julieMSFT
 ms.author: jrasnick
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # OBJECT_SCHEMA_NAME (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/functions/session-context-transact-sql.md b/docs/t-sql/functions/session-context-transact-sql.md
@@ -18,6 +18,7 @@ helpviewer_keywords:
 ms.assetid: b6bdbc54-331a-43cc-ab3d-3872d6a12100
 author: VanMSFT
 ms.author: vanto
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest"
 ---
 # SESSION_CONTEXT (Transact-SQL)
 [!INCLUDE [sqlserver2016-asdb-asdbmi-asa](../../includes/applies-to-version/sqlserver2016-asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/functions/suser-name-transact-sql.md b/docs/t-sql/functions/suser-name-transact-sql.md
@@ -27,7 +27,7 @@ ms.author: vanto
 monikerRange: "=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # SUSER_NAME (Transact-SQL)
-[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi.md)]
+[!INCLUDE [SQL Server Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdbmi-asa-svrless-poolonly.md)]
 
 Returns the login identification name of the user.  
   
diff --git a/docs/t-sql/language-elements/null-and-unknown-transact-sql.md b/docs/t-sql/language-elements/null-and-unknown-transact-sql.md
@@ -12,7 +12,8 @@ dev_langs:
 ms.assetid: 9d491846-4730-4740-a680-77c69fae4a58
 author: MikeRayMSFT
 ms.author: mikeray
-monikerRange: ">=aps-pdw-2016||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: ">=aps-pdw-2016||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current || =azure-sqldw-latest
+"
 ---
 # NULL and UNKNOWN (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa-pdw](../../includes/applies-to-version/sql-asdb-asdbmi-asa-pdw.md)]
diff --git a/docs/t-sql/language-elements/slash-star-comment-transact-sql.md b/docs/t-sql/language-elements/slash-star-comment-transact-sql.md
@@ -22,6 +22,7 @@ helpviewer_keywords:
 ms.assetid: 4d9ab1b2-4bbb-4c16-beb1-cafc1af7417c
 author: cawrites
 ms.author: chadam
+monikerRange: "= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || =azure-sqldw-latest ||>= aps-pdw-2016 "
 ---
 
 # Slash Star (Block Comment) (Transact-SQL)
diff --git a/docs/t-sql/lesson-1-creating-database-objects.md b/docs/t-sql/lesson-1-creating-database-objects.md
@@ -10,10 +10,10 @@ ms.topic: conceptual
 ms.assetid: 9fb8656b-0e4e-4ada-b404-4db4d3eea995
 author: MikeRayMSFT
 ms.author: mikeray
-monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: ">=aps-pdw-2016||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Lesson 1: Create and query database objects
-[!INCLUDE[tsql-appliesto-ss2008-all-md](../includes/tsql-appliesto-ss2008-all-md.md)]
+[!INCLUDE[sql-asdb-asdbmi-pdw-md](../applies-to-version/includes/sql-asdb-asdbmi-pdw.md)]
 
 This lesson shows you how to create a database, create a table in the database, and then access and change the data in the table. Because this lesson is an introduction to using [!INCLUDE[tsql](../includes/tsql-md.md)], it does not use or describe the many options that are available for these statements.  
   
diff --git a/docs/t-sql/lesson-2-configuring-permissions-on-database-objects.md b/docs/t-sql/lesson-2-configuring-permissions-on-database-objects.md
@@ -12,10 +12,12 @@ helpviewer_keywords:
 ms.assetid: f964b66a-ec32-44c2-a185-6a0f173bfa22
 author: MikeRayMSFT
 ms.author: mikeray
-monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: ">=aps-pdw-2016||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Lesson 2: Configure permissions on database objects
-[!INCLUDE[tsql-appliesto-ss2008-all-md](../includes/tsql-appliesto-ss2008-all-md.md)]
+
+[!INCLUDE[sql-asdb-asdbmi-pdw-md](../applies-to-version/includes/sql-asdb-asdbmi-pdw.md)]
+
 Granting a user access to a database involves three steps. First, you create a login. The login lets the user connect to the [!INCLUDE[ssDEnoversion](../includes/ssdenoversion-md.md)]. Then you configure the login as a user in the specified database. And finally, you grant that user permission to database objects. This lesson shows you these three steps, and shows you how to create a view and a stored procedure as the object.  
 
   >[!NOTE]
diff --git a/docs/t-sql/lesson-3-deleting-database-objects.md b/docs/t-sql/lesson-3-deleting-database-objects.md
@@ -12,10 +12,12 @@ helpviewer_keywords:
 ms.assetid: ecf26dd5-4535-4ed6-86fc-c73f9d9dedec
 author: MikeRayMSFT
 ms.author: mikeray
-monikerRange: ">=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: ">=aps-pdw-2016||=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # Lesson 3: Delete database objects
-[!INCLUDE[tsql-appliesto-ss2008-all-md](../includes/tsql-appliesto-ss2008-all-md.md)]
+
+[!INCLUDE[sql-asdb-asdbmi-pdw-md](../applies-to-version/includes/sql-asdb-asdbmi-pdw.md)]
+
 This short lesson removes the objects that you created in Lesson 1 and Lesson 2, and then drops the database.  
   
 Before you delete objects, make sure you are in the correct database:
diff --git a/docs/t-sql/spatial-geography/stintersects-geography-data-type.md b/docs/t-sql/spatial-geography/stintersects-geography-data-type.md
@@ -18,7 +18,7 @@ helpviewer_keywords:
 ms.assetid: c9db8b42-83c7-48c6-8963-fce54eb34c05
 author: MladjoA
 ms.author: mlandzic 
-monikerRange: "=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: "=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # STIntersects (geography Data Type)
 [!INCLUDE [SQL Server Azure SQL Database Azure SQL Managed Instance](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
diff --git a/docs/t-sql/spatial-geometry/bufferwithcurves-geometry-data-type.md b/docs/t-sql/spatial-geometry/bufferwithcurves-geometry-data-type.md
@@ -15,7 +15,7 @@ helpviewer_keywords:
 ms.assetid: 8ffaba3f-d2dd-4e57-9f41-3ced9f14b600
 author: MladjoA
 ms.author: mlandzic 
-monikerRange: "=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
+monikerRange: ">=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current"
 ---
 # BufferWithCurves (geometry Data Type)
 [!INCLUDE[sql-asdb-asdbmi](../../includes/applies-to-version/sql-asdb-asdbmi.md)]
diff --git a/docs/t-sql/statements/add-sensitivity-classification-transact-sql.md b/docs/t-sql/statements/add-sensitivity-classification-transact-sql.md
@@ -22,7 +22,7 @@ helpviewer_keywords:
   - "rank"
 ms.custom: ""
 ms.date: 06/10/2020
-monikerRange: " >= sql-server-linux-ver15 || >= sql-server-ver15 || = azuresqldb-current"
+monikerRange: " >= sql-server-linux-ver15 || >= sql-server-ver15 || = azuresqldb-current || =azure-sqldw-latest"
 ---
 
 # ADD SENSITIVITY CLASSIFICATION (Transact-SQL)
diff --git a/docs/t-sql/statements/drop-database-scoped-credential-transact-sql.md b/docs/t-sql/statements/drop-database-scoped-credential-transact-sql.md
@@ -17,7 +17,7 @@ helpviewer_keywords:
 ms.assetid: 319d59f4-fa82-47ca-869b-3a9cd52900b0
 author: VanMSFT
 ms.author: vanto
-monikerRange: "= azuresqldb-current"
+monikerRange: "= azuresqldb-current || =azure-sqldw-latest"
 ---
 # DROP DATABASE SCOPED CREDENTIAL (Transact-SQL)
 [!INCLUDE [asdb-asdbmi-asa](../../includes/applies-to-version/asdb-asdbmi-asa.md)]
diff --git a/docs/t-sql/statements/drop-sensitivity-classification-transact-sql.md b/docs/t-sql/statements/drop-sensitivity-classification-transact-sql.md
@@ -24,7 +24,7 @@ helpviewer_keywords:
   - "labels [SQL]"
   - "information types"
   - "data classification"
-monikerRange: " >= sql-server-ver15 || = azuresqldb-current"
+monikerRange: " >= sql-server-ver15 || = azuresqldb-current || =azure-sqldw-latest"
 ---
 # DROP SENSITIVITY CLASSIFICATION (Transact-SQL)
 [!INCLUDE [sql-asdb-asdbmi-asa](../../includes/applies-to-version/sql-asdb-asdbmi-asa.md)]
