Skip to content

Commit eb36c40

Browse files
PRMerger5PRMerger5
authored
Merge pull request #21883 from MicrosoftDocs/WilliamDAssafMSFT-patch-2
20220428 Update version labels and monikers for create-external-data-source-transact-sql.md
2 parents 445041c + 550e79c commit eb36c40

1 file changed

Lines changed: 18 additions & 19 deletions

File tree

‎docs/t-sql/statements/create-external-data-source-transact-sql.md‎

Lines changed: 18 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
description: "CREATE EXTERNAL DATA SOURCE (Transact-SQL)"
33
title: "CREATE EXTERNAL DATA SOURCE (Transact-SQL)"
44
ms.custom: ""
5-
ms.date: 4/06/2022
5+
ms.date: 4/28/2022
66
ms.prod: sql
77
ms.prod_service: "database-engine, sql-database, synapse-analytics, pdw"
88
ms.reviewer: ""
@@ -31,7 +31,7 @@ This article provides the syntax, arguments, remarks, permissions, and examples
3131
[!INCLUDE[select-product](../../includes/select-product.md)]
3232

3333
<!-- In addition to moniker ranges for SQL Server, SQL DB, APS, Synapse, and SQL MI,
34-
this article has version moniker ranges for SQL Server 2016, 2017, and 2019 due to the syntax differences between each.
34+
this article has version moniker ranges for SQL Server 2016, 2017 (Windows and Linux), and 2019 due to the syntax differences between each.
3535
Use of the version selector above the TOC is important for this document.-->
3636
<!-- At this time the Azure SQL Edge moniker azuresqledge-current is not functional in sql-docs.
3737
Per PMs, we have added Azure SQL Edge content to Azure SQL DB range. -->
@@ -71,12 +71,12 @@ Creates an external data source for PolyBase queries. External data sources are
7171
- Data virtualization and data load using [PolyBase][intro_pb]
7272
- Bulk load operations using `BULK INSERT` or `OPENROWSET`
7373

74-
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
74+
> [!NOTE]
75+
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019 and later, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-linux-ver15&preserve-view=true#syntax).
7576
7677
## <a id="syntax"></a> Syntax for SQL Server 2016
7778

78-
> [!NOTE]
79-
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-linux-ver15&preserve-view=true#syntax).
79+
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
8080

8181
```syntaxsql
8282
CREATE EXTERNAL DATA SOURCE <data_source_name>
@@ -297,36 +297,35 @@ WITH
297297
::: moniker range="=sql-server-2017||=sql-server-linux-2017"
298298

299299
## Overview: SQL Server
300-
[!INCLUDE[SQL2016+](../../includes/applies-to-version/sqlserver2016.md)]
300+
[!INCLUDE[SQL2017 only](../../includes/applies-to-version/sqlserver2017-only.md)]
301301

302302
Creates an external data source for PolyBase queries. External data sources are used to establish connectivity and support these primary use cases:
303303

304304
- Data virtualization and data load using [PolyBase][intro_pb]
305305
- Bulk load operations using `BULK INSERT` or `OPENROWSET`
306306

307-
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
308-
309-
## <a id="syntax"></a> Syntax for SQL Server 2017
310-
311307
::: moniker-end
312308

313309
::: moniker range="=sql-server-linux-2017"
314310

315311
> [!NOTE]
316-
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-linux-ver15&preserve-view=true#syntax).
312+
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019 and later, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-linux-ver15&preserve-view=true#syntax).
317313
318314
::: moniker-end
319315

320316
::: moniker range="=sql-server-2017"
321317

322318
> [!NOTE]
323-
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-ver15&preserve-view=true#syntax).
324-
319+
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. To view the features of SQL Server 2019 and later, see [CREATE EXTERNAL DATA SOURCE](create-external-data-source-transact-sql.md?view=sql-server-ver15&preserve-view=true#syntax).
325320
326321
::: moniker-end
327322

328323
::: moniker range="=sql-server-2017||=sql-server-linux-2017"
329324

325+
## <a id="syntax"></a> Syntax for SQL Server 2017
326+
327+
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
328+
330329
```syntaxsql
331330
CREATE EXTERNAL DATA SOURCE <data_source_name>
332331
WITH
@@ -591,22 +590,22 @@ To see this example in use, see the [BULK INSERT][bulk_insert_example] example.
591590

592591
::: moniker-end
593592

594-
::: moniker range="=sql-server-ver15"
593+
::: moniker range=">=sql-server-ver15"
595594

596595
## Overview: SQL Server
597-
[!INCLUDE[SQL2016+](../../includes/applies-to-version/sqlserver2016.md)]
596+
[!INCLUDE[SQL2019](../../includes/applies-to-version/sqlserver2019.md)] and later
598597

599598
Creates an external data source for PolyBase queries. External data sources are used to establish connectivity and support these primary use cases:
600599

601600
- Data virtualization and data load using [PolyBase][intro_pb]
602601
- Bulk load operations using `BULK INSERT` or `OPENROWSET`
603602

604-
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
603+
> [!NOTE]
604+
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server. This content applies to SQL Server 2019 and later.
605605
606-
## <a id="syntax"></a> Syntax for SQL Server 2019
606+
## <a id="syntax"></a> Syntax for SQL Server 2019 and later
607607

608-
> [!NOTE]
609-
> This syntax varies between versions of SQL Server. Use the version selector dropdown to choose the appropriate version of SQL Server.
608+
For more information about the syntax conventions, see [Transact-SQL Syntax Conventions](../../t-sql/language-elements/transact-sql-syntax-conventions-transact-sql.md).
610609

611610
```syntaxsql
612611
CREATE EXTERNAL DATA SOURCE <data_source_name>

0 commit comments

Comments
 (0)