版本設定和 applies-to 的 SQL Server include 檔案
您可使用 Markdown 中的 include 檔案輕鬆修改文件中的參考，並不需變更個別文章的實際文字。 在 SQL 內容世界中，include 檔案有三種類型：SQL 版本、applies-to 與參考性文字。 SQL Server 版本 Include 檔案用來指出目前所討論的 SQL 版本，例如 SQL Server 2016 或 2017。 Applies-to Include 檔案指出文件適用於哪些 SQL 產品和服務，例如 Linux 上的 SQL Server 或 Azure SQL Database。 參考性文字 Include 檔案不屬於上述兩種類型，例如「取得說明」Include 檔案是客戶可用來取得 SQL Server 說明的連結清單。
此文章旨在作為前兩種 Include 檔案類型的參考點。 您可以在 sql-docs 存放庫中瀏覽 include 檔案的完整清單。
SQL Server 版本 Include 檔案
SQL 內容作者通常需要包括 SQL Server 的產品名稱與版本。 如此一來，若名稱有所變更，會更新 include 檔案，而不需在每篇文章中手動更新值。 這些 include 檔案用來作為產品名稱的預留位置，但並未在所有 SQL 文件中一致地使用。 SQL Server vNext 指的是目前尚未有版本號碼的未來 SQL 版本，而且是此處所述內容的例外。
| SQL 版本 | 檔案名稱 | Markdown 範例 | Text |
|---|---|---|---|
| SQL Server | ssnoversion-md.md | [!INCLUDE[ssSQL11](../includes/ssnoversion-md.md)] |
SQL Server |
| SQL Server 2000 | ssversion2000-md.md | [!INCLUDE[ssSQL11](../includes/ssversion2000-md.md)] |
SQL Server 2000 (8.x) |
| SQL Server 2005 | ssversion2005-md.md | [!INCLUDE[ssSQL11](../includes/ssversion2005-md.md)] |
SQL Server 2005 (9.x) |
| SQL Server 2008 | sql2008-md.md | [!INCLUDE[sql2008-md](../includes/sql2008-md.md)] |
SQL Server 2008 (10.0.x) |
| SQL Server 2008 R2 | sql2008r2-md.md | [!INCLUDE [sql2008r2-md](../includes/sql2008r2-md.md)] |
SQL Server 2008 R2 (10.50.x) |
| SQL Server 2012 | sssql11-md.md | [!INCLUDE[ssSQL11](../includes/sssql11-md.md)] |
SQL Server 2012 (11.x) |
| SQL Server 2012 SP1 | sssql11sp1-md.md | [!INCLUDE[ssSQL11SP1](../includes/sssql11sp1-md.md)] |
SQL Server 2012 SP1 (11.0.3x) |
| SQL Server 2014 | sssql14-md.md | [!INCLUDE[ssSQL14](../includes/sssql14-md.md)] |
SQL Server 2014 (12.x) |
| SQL Server 2016 | sssql16-md.md | [!INCLUDE[sssql15-md](../includes/sssql16-md.md)] |
SQL Server 2016 (13.x) |
| SQL Server 2017 | sssql17-md.md | [!INCLUDE[sssql17-md](../includes/sssql17-md.md)] |
SQL Server 2017 (14.x) |
| SQL Server 2019 | sssql19-md.md | [!INCLUDE[sssql19-md](../includes/sssql19-md.md)] |
SQL Server 2019 (15.x) |
| SQL Server vNext | sssql22-md.md | [!INCLUDE[sssql22-md](../includes/sssql22-md.md)] |
SQL Server 2022 (16.x) |
SQL Server 的 Applies-to (非版本特定)
這些 Applies-to Include 檔案會省略 SQL Server 版本。
| 檔案名稱 | Markdown 範例 | 影像 |
|---|---|---|
| appliesto-ss-asdb-asdw-xxx-md.md | [!INCLUDE[SQL Server ASDB, ASDBMI, ASDW](../includes/applies-to-version/sql-asdb-asdbmi-asa.md)] |
適用於：  AzureSQL Server Azure SQL 資料庫 Azure SQL 受控執行個體 Azure Synapse Analytics |
| appliesto-ss-asdb-xxxx-pdw-md.md | [!INCLUDE[appliesto-ss-asdb-xxxx-pdw-md.md](../includes/appliesto-ss-asdb-xxxx-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫  Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-asdb-xxxx-xxx-md.md | [!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md.md](../includes/applies-to-version/sql-asdb.md)] |
適用於： SQL Server Azure SQL 資料庫 |
| applies-to-version/sql-asdbmi.md | [!INCLUDE[applies-to-version/sql-asdbmi.md](../includes/applies-to-version/sql-asdbmi.md)] |
適用於：SQL Server Azure SQL 受控執行個體 |
| appliesto-ss-xxxx-asdw-pdw-md.md | [!INCLUDE[appliesto-ss-xxxx-asdw-pdw-md.md](../includes/appliesto-ss-xxxx-asdw-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-xxxx-xxxx-pdw-md.md | [!INCLUDE[appliesto-ss-xxxx-xxxx-pdw-md.md](../includes/appliesto-ss-xxxx-xxxx-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-xxxx-xxxx-xxx-md-winonly.md | [!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-winonly.md](../includes/appliesto-ss-xxxx-xxxx-xxx-md-winonly.md)] |
適用於： SQL Server (僅限 Windows) Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| applies-to-version/_ssnoversion.md | [!INCLUDE[applies-to-version/_ssnoversion.md](../includes/applies-to-version/sqlserver.md)] |
適用於：SQL Server |
| appliesto-xx-asdb-asdw-xxx-md.md | [!INCLUDE[appliesto-xx-asdb-asdw-xxx-md.md](../includes/appliesto-xx-asdb-asdw-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-xx-asdb-xxxx-xxx-md.md | [!INCLUDE[appliesto-xx-asdb-xxxx-xxx-md.md](../includes/appliesto-xx-asdb-xxxx-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
SQL Server 的 Applies-to (版本特定)
這些 Applies-to Include 檔案會指定文件適用於哪些 SQL 版本。
| 檔案名稱 | Markdown 範例 | 映像 |
|---|---|---|
| applies-to-version/asa-pdw.md | [!INCLUDE[applies-to-version/asa-pdw.md](../includes/applies-to-version/asa-pdw.md)] |
適用於：Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-asdb-asdw-xxx-md.md | [!INCLUDE[appliesto-ss-asdb-asdw-xxx-md.md](../includes/appliesto-ss-asdb-asdw-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-asdb-xxxx-pdw-md.md | [!INCLUDE[appliesto-ss-asdb-xxxx-pdw-md.md](../includes/appliesto-ss-asdb-xxxx-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-asdb-xxxx-xxx-md.md | [!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md.md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-xxxx-asdw-pdw-md.md | [!INCLUDE[appliesto-ss-xxxx-asdw-pdw-md.md](../includes/appliesto-ss-xxxx-asdw-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss-xxxx-xxxx-pdw-md.md | [!INCLUDE[appliesto-ss-xxxx-xxxx-pdw-md.md](../includes/appliesto-ss-xxxx-xxxx-pdw-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-ss2016-asdb-asdw-pdw-md.md | [!INCLUDE[appliesto-ss2016-asdb-asdw-pdw-md.md](appliesto-ss2016-asdb-asdw-pdw-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-xx-asdb-asdw-xxx-md.md | [!INCLUDE[appliesto-xx-asdb-asdw-xxx-md.md](../includes/appliesto-xx-asdb-asdw-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| appliesto-xx-asdb-xxxx-xxx-md.md | [!INCLUDE[appliesto-xx-asdb-xxxx-xxx-md.md](../includes/appliesto-xx-asdb-xxxx-xxx-md.md)] |
適用於： SQL Server Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| sqlserver2017-asdb.md | [!INCLUDE[sqlserver2017-asdb.md](../includes/applies-to-version/sqlserver2017-asdb.md)] |
適用於：SQL Server 2017 (14.x) 和更新版本 Azure SQL 資料庫 |
| tsql-appliesto-2014sp2-asdb-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-2014sp2-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-2014sp2-asdb-xxxx-xxx-md.md)] |
適用於：SQL Server 2014 Azure SQL Database Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-2016sp2-asdb-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-2016sp2-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-2016sp2-asdb-xxxx-xxx-md.md)] |
適用於： SQL Server 2016 (13.x) SP 2 和更新版本 Azure SQL Database Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2008-asdbmi-xxxx-pdw-md.md | [!INCLUDE[tsql-appliesto-ss2008-asdbmi-xxxx-pdw-md.md](../includes/tsql-appliesto-ss2008-asdbmi-xxxx-pdw-md.md)] |
適用於：SQL Server Azure SQL 受控執行個體 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver.md)] |
適用於：SQL Server |
| tsql-appliesto-ss2016-asdb-asdw-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2016-asdb-asdw-xxx-md.md](../includes/tsql-appliesto-ss2016-asdb-asdw-xxx-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2016-asdb-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2016-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2016-asdb-xxxx-xxx-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2016-xxxx-asdw-pdw-md.md | [!INCLUDE[tsql-appliesto-ss2016-xxxx-asdw-pdw-md.md](../includes/tsql-appliesto-ss2016-xxxx-asdw-pdw-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2016-xxxx-asdw-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2016-xxxx-asdw-xxx-md.md](../includes/tsql-appliesto-ss2016-xxxx-asdw-xxx-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2016-xxxx-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2016-xxxx-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2016-xxxx-xxxx-xxx-md.md)] |
適用於： SQL Server 2016 (13.x) 和更新版本 Azure SQL 資料庫 Azure Synapse Analytics Analytics Platform System (PDW) |
| tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md | [!INCLUDE[tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver2017.md)] |
適用於：SQL Server 2017 (14.x) 和更新版本 |
Analysis Services 的 Applies-to
這些 Applies-to Include 檔案與 Analysis Services 文件搭配使用。
| 檔案名稱 | Markdown 範例 | 映像 |
|---|---|---|
| ssas-appliesto-sql2016.md | [!INCLUDE[ssas-appliesto-sql2016.md](../includes/ssas-appliesto-sql2016.md)] |
適用於：✅ SQL Server 2016 (13.x) Analysis Services Azure Analysis Services Power BI Premium |
| ssas-appliesto-sql2016-later.md | [!INCLUDE[ssas-appliesto-sql2016-later.md](../includes/ssas-appliesto-sql2016-later.md)] |
適用於：✅ SQL Server 2016 (13.x) Analysis Services 和更新版本 Azure Analysis Services Power BI Premium |
| ssas-appliesto-sql2016-later-aas.md | [!INCLUDE[ssas-appliesto-sql2016-later-aas.md](../includes/ssas-appliesto-sql2016-later-aas.md)] |
適用於：✅ SQL Server 2016 (13.x) Analysis Services 和更新版本 Azure Analysis Services Power BI Premium |
| ssas-appliesto-sql2017.md | [!INCLUDE[ssas-appliesto-sql2017.md](../includes/ssas-appliesto-sql2017.md)] |
適用於：✅ SQL Server 2017 Analysis Services ❌ Azure Analysis Services ❌ Power BI Premium |
| ssas-appliesto-sql2017-later-aas.md | [!INCLUDE[ssas-appliesto-sql2017-later-aas.md](../includes/ssas-appliesto-sql2017-later-aas.md)] |
適用於：✅ SQL Server 2017 Analysis Services 和更新版本 ✅ Azure Analysis Services ❌ Power BI Premium |
| ssas.md | [!INCLUDE[ssas.md](../includes/applies-to-version/ssas.md)] |
適用於：SQL Server Analysis Services |
| ssas-appliesto-sqlas-all-aas.md | [!INCLUDE[ssas-aas.md](../includes/ssas-appliesto-sqlas-all-aas.md)] |
適用於：✅ SQL Server Analysis Services ✅ Azure Analysis Services ❌ Power BI Premium |
| ssas-appliesto-sqlas-all.md | [!INCLUDE[ssas-all.md](../includes/ssas-appliesto-sqlas-all.md)] |
適用於：✅ SQL Server Analysis Services ❌ Azure Analysis Services ❌ Power BI Premium |
| ssas-appliesto-sqlas-all-aas.md | [!INCLUDE[ssas-all-aas.md](../includes/ssas-appliesto-sqlas-all-aas.md)] |
適用於：✅ SQL Server Analysis Services ✅ Azure Analysis Services ❌ Power BI Premium |
Reporting Services 的 Applies-to
這些 Applies-to Include 檔案與 Reporting Services 文件搭配使用。
| 檔案名稱 | Markdown 範例 | 映像 |
|---|---|---|
| ssrs-appliesto-2017-and-later.md | [!INCLUDE[ssrs-appliesto-2017-and-later.md](../includes/ssrs-appliesto-2017-and-later.md)] |
SQL Server Reporting Services (2017 和更新版本) |
| ssrs-appliesto-not-pbirs.md | [!INCLUDE[ssrs-appliesto-not-pbirs.md](../includes/ssrs-appliesto-not-pbirs.md)] |
❌ Power BI 報表伺服器 |
| ssrs-appliesto-pbirs.md | [!INCLUDE[ssrs-appliesto-pbirs.md](../includes/ssrs-appliesto-pbirs.md)] |
Power BI 報表伺服器 |
| ssrs-appliesto-sharepoint-2013-2016.md | [!INCLUDE[ssrs-appliesto-sharepoint-2013-2016.md](../includes/ssrs-appliesto-sharepoint-2013-2016.md)] |
SharePoint |
| ssrs-appliesto-sql2016-preview.md | [!INCLUDE[ssrs-appliesto-sql2016-preview.md](../includes/ssrs-appliesto-sql2016-preview.md)] |
適用於：SQL Server 2016 (13.x) Power BI 報表伺服器 |
後續步驟
如需有關如何使用這些 include 檔案的詳細資訊，請參閱 Applies-to include 檔案。