SQL Server include 文件,用于版本控制和 applies-to

通过使用 Markdown 中的 Include 文件,可以轻松修改文档中的引用,而无需更改各个文章的实际文本。 在 SQL 内容中有三种类型的 include 文件:SQL 版本、applies-to 和引用文本。 SQL Server 版本 include 文件用于指示讨论的 SQL 版本,例如 SQL Server 2016 或 2017 。 applies-to include 文件指示文档适用于什么 SQL 产品和服务,例如 Linux 上的 SQL Server 或 Azure SQL 数据库 。 引用文本 include 文件不属于其他两个类别,例如“Get Help” include - 客户可用于获得 SQL Server 相关帮助的链接列表 。

本文仅用作前两种类型的 include 文件的参考点。 可通过 sql-docs 存储库浏览 include 文件的完整列表。

SQL Server 版本 include 文件

SQL 内容写入程序经常需要添加 SQL Server 的产品名称和版本。 这样一来,如果名称发生了某些更改,将更新 include 文件,而不是手动更新每个文章的值。 这些 include 文件用作产品名称的占位符,但尚未在所有 SQL 文档中一致地使用。 SQL Server vNext 是指尚不具有版本号的 SQL 的未来版本,它在此情况中是一个特例。

SQL 版本 文件名 Markdown 示例 文本
SQL ssnoversion-md.md [!INCLUDE[ssSQL11](../includes/ssnoversion-md.md)] SQL Server
SQL 2000 ssversion2000-md.md [!INCLUDE[ssSQL11](../includes/ssversion2000-md.md)] SQL Server 2000 (8.x)
SQL 2005 ssversion2005-md.md [!INCLUDE[ssSQL11](../includes/ssversion2005-md.md)] SQL Server 2005 (9.x)
SQL 2012 sssql11-md.md [!INCLUDE[ssSQL11](../includes/sssql11-md.md)] SQL Server 2012 (11.x)
SQL 2012 SP1 sssql11sp1-md.md [!INCLUDE[ssSQL11SP1](../includes/sssql11sp1-md.md)] SQL Server 2012 SP1 (11.0.3x)
SQL 2014 sssql14-md.md [!INCLUDE[ssSQL14](../includes/sssql14-md.md)] SQL Server 2014 (12.x)
SQL 2016 sssql16-md.md [!INCLUDE[sssql15-md](../includes/sssql16-md.md)] SQL Server 2016 (13.x)
SQL 2017 sssql17-md.md [!INCLUDE[sssql17-md](../includes/sssql17-md.md)] SQL Server 2017 (14.x)
SQL 2017 sssql17-md.md [!INCLUDE[sssql14](../includes/sssql17-md.md)] SQL Server 2017 (14.x)
SQL vNext sssql19-md.md [!INCLUDE[sssql19-md](../includes/sssql19-md.md)] SQL Server vNext
       

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)] 适用于:yesSQL Server (所有受支持的版本) Yes Azure SQL 数据库 Yes azure SQL 托管实例 yes azure Synapse Analytics
appliesto-ss-asdb-asdw-pdw-md.md [!INCLUDE[appliesto-ss-asdb-asdw-pdw-md.md](../includes/appliesto-ss-asdb-asdw-pdw-md.md)] 适用于:SQL Server 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 并行数据仓库
appliesto-ss-asdb-xxxx-xxx-md.md [!INCLUDE[appliesto-ss-asdb-xxxx-xxx-md.md](../includes/applies-to-version/sql-asdb.md)] 适用于:yesSQL Server (所有受支持的版本) Yes Azure SQL 数据库
applies-to-version/sql-asdbmi.md [!INCLUDE[applies-to-version/sql-asdbmi.md](../includes/applies-to-version/sql-asdbmi.md)] 适用于:yes (所有受支持的版本的 SQL Server) YesAzure 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 并行数据仓库
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 并行数据仓库
appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md [!INCLUDE[appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md](../includes/appliesto-ss-xxxx-xxxx-xxx-md-linuxonly.md)] 适用于:仅 SQL Server (Linux) Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
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 并行数据仓库
applies-to-version/_ssnoversion.md [!INCLUDE[applies-to-version/_ssnoversion.md](../includes/applies-to-version/sqlserver.md)] 适用于:yes (所有受支持的版本的 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 并行数据仓库
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 并行数据仓库
appliesto-xx-xxxx-asdw-pdw-md.md [!INCLUDE[appliesto-xx-xxxx-asdw-pdw-md.md](../includes/appliesto-xx-xxxx-asdw-pdw-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
appliesto-xx-xxxx-asdw-xxx-md.md [!INCLUDE[appliesto-xx-xxxx-asdw-xxx-md.md](../includes/appliesto-xx-xxxx-asdw-xxx-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
     

SQL Server Applies-to(特定版本)

这些 applies-to include 文件指定文档适用的 SQL 版本。

文件名 Markdown 示例 映像
tsql-appliesto-ss2008-all-md.md [!INCLUDE[tsql-appliesto-ss2008-all-md.md](../includes/tsql-appliesto-ss2008-all-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
tsql-appliesto-ss2008-all-md.md [!INCLUDE[tsql-appliesto-ss2008-all-md.md](../includes/tsql-appliesto-ss2008-all-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
tsql-appliesto-ss2008-asdb-asdw-xxx-md.md [!INCLUDE[tsql-appliesto-ss2008-asdb-asdw-xxx-md.md](../includes/tsql-appliesto-ss2008-asdb-asdw-xxx-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
tsql-appliesto-ss2008-asdbmi-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2008-asdbmi-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2008-asdbmi-xxxx-xxx-md.md)] 适用于:SQL Server azure SQL 托管实例 azure Synapse Analytics 并行数据仓库
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 并行数据仓库
tsql-appliesto-ss2008-asdb-xxxx-pdw-md.md [!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-pdw-md.md](../includes/tsql-appliesto-ss2008-asdb-xxxx-pdw-md.md)] 适用于:SQL Server Azure SQL 数据库 Azure Synapse Analytics 并行数据仓库
tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2008-asdb-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2008-xxxx-asdw-pdw-md.md [!INCLUDE[tsql-appliesto-ss2008-xxxx-asdw-pdw-md.md](../includes/tsql-appliesto-ss2008-xxxx-asdw-pdw-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2008-xxxx-asdw-xxx-md.md [!INCLUDE[tsql-appliesto-ss2008-xxxx-asdw-xxx-md.md](../includes/tsql-appliesto-ss2008-xxxx-asdw-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver.md)] 适用于:yesSQL Server (支持的所有)
tsql-appliesto-ss2012-all-md.md [!INCLUDE[tsql-appliesto-ss2012-all-md.md](tsql-appliesto-ss2012-all-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2012-asdb-asdw-xxx-md.md [!INCLUDE[tsql-appliesto-ss2012-asdb-asdw-xxx-md.md](../includes/tsql-appliesto-ss2012-asdb-asdw-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2012-asdbmi-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2012-asdbmi-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2012-asdbmi-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 托管实例 Azure Synapse Analytics 并行Data Warehouse
tsql-appliesto-ss2012-asdb-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2012-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2012-asdb-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2012-xxxx-xxxx-pdw-md.md [!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-pdw-md.md](../includes/tsql-appliesto-ss2012-xxxx-xxxx-pdw-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2012-xxxx-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2014-asdb-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2014-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2014-asdb-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2014-xxxx-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2014-xxxx-xxxx-xxx-md.md](../includes/tsql-appliesto-ss2014-xxxx-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 数据库 Azure Synapse Analytics Parallel Data Warehouse
tsql-appliesto-ss2016-all-md.md [!INCLUDE[tsql-appliesto-ss2016-all-md.md](tsql-appliesto-ss2016-all-md.md)] 适用于:SQL Server 2016 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
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 及更高版本Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly.md [!INCLUDE[tsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly.md](../includes/tsql-appliesto-ss2016-xxxx-xxxx-xxx-md-winonly.md)] 适用于:SQL Server 2016 及更高版本 (Windows仅) Azure SQL 数据库Azure Synapse Analytics 并行Data Warehouse
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 SP 2 及更高版本Azure SQL 数据库Azure Synapse Analytics 并行Data Warehouse
tsql-appliesto-ss2017-all-md.md [!INCLUDE[tsql-appliesto-ss2017-all-md.md](tsql-appliesto-ss2017-all-md.md)] 适用于:SQL Server 2017 及更高版本Azure SQL 数据库Azure Synapse Analytics 并行Data Warehouse
tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver2017.md)] 适用于:yesSQL Server 2017 (14.x) 及更高版本
sqlserver2017-asdb.md [!INCLUDE[sqlserver2017-asdb.md](../includes/applies-to-version/sqlserver2017-asdb.md)] 适用于:yesSQL Server 2017 (14.x) 及更高版本Azure SQL 数据库Yes
tsql-appliesto-xxxxxx-asdb-asdw-xxx-md.md [!INCLUDE[tsql-appliesto-xxxxxx-asdb-asdw-xxx-md.md](../includes/tsql-appliesto-xxxxxx-asdb-asdw-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-xxxxxx-asdb-xxxx-xxx-md.md [!INCLUDE[tsql-appliesto-xxxxxx-asdb-xxxx-xxx-md.md](../includes/tsql-appliesto-xxxxxx-asdb-xxxx-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
applies-to-version/asa-pdw.md [!INCLUDE[applies-to-version/asa-pdw.md](../includes/applies-to-version/asa-pdw.md)] 适用于:yesyesAzure Synapse Analytics Analytics Platform System (PDW)
tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md.md [!INCLUDE[tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md.md](../includes/tsql-appliesto-xxxxxx-xxxx-asdw-xxx-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
tsql-appliesto-xxxxxx-xxxx-xxxx-pdw-md.md [!INCLUDE[tsql-appliesto-xxxxxx-xxxx-xxxx-pdw-md.md](../includes/tsql-appliesto-xxxxxx-xxxx-xxxx-pdw-md.md)] 适用于: SQL Server Azure SQL 数据库 Azure Synapse Analytics并行Data Warehouse
     

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 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 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 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)] 适用于:yesSQL Server Analysis Services
ssas-appliesto-sqlas-aas.md [!INCLUDE[ssas-aas.md](../includes/ssas-appliesto-sqlas-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 Power BI 报表服务器
     

后续步骤

要详细了解如何使用这些 include 文件,请参阅 Applies-to include

这是测试