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 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)] |
适用于：  SQL 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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 数据库 Azure Synapse Analytics 分析平台系统 (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 数据库 Azure Synapse Analytics 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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 分析平台系统 (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。