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)] |
适用于： SQL Server (所有受支持的版本) Azure SQL 数据库 azure SQL 托管实例 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)] |
适用于：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 并行数据仓库 |
| 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)] |
适用于： (所有受支持的版本的 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)] |
适用于：SQL 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)] |
适用于：SQL Server 2017 (14.x) 及更高版本 |
| sqlserver2017-asdb.md | [!INCLUDE[sqlserver2017-asdb.md](../includes/applies-to-version/sqlserver2017-asdb.md)] |
适用于：SQL Server 2017 (14.x) 及更高版本Azure SQL 数据库 |
| 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)] |
适用于：Azure 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)] |
适用于：SQL 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。
这是测试