分享方式:


版本設定和 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 檔案