通过使用 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 文件,而不是手动更新每个文章的值。 这些包含的文件用作产品名称的占位符,但尚未在所有 SQL 文档中一致地使用。 SQL Server vNext 是指将来的 SQL 版本,该版本没有版本号,但这种情况是例外。
SQL Server 版本 | 文件名 | markdown 示例 | 文本 |
---|---|---|---|
SQL Server | ssnoversion-md.md | [!INCLUDE [ssnoversion-md](../includes/ssnoversion-md.md)] |
SQL Server |
SQL Server 2000 | ssversion2000-md.md | [!INCLUDE [ssversion2000-md](../includes/ssversion2000-md.md)] |
SQL Server 2000 (8.x) |
SQL Server 2005 | ssversion2005-md.md | [!INCLUDE [ssversion2005-md](../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-md](../includes/sssql11-md.md)] |
SQL Server 2012 (11.x) |
SQL Server 2012 SP1 | sssql11sp1-md.md | [!INCLUDE [sssql11sp1-md](../includes/sssql11sp1-md.md)] |
SQL Server 2012 SP1 (11.0.3x) |
SQL Server 2014 | sssql14-md.md | [!INCLUDE [sssql14-md](../includes/sssql14-md.md)] |
SQL Server 2014 (12.x) |
SQL Server 2016 | sssql16-md.md | [!INCLUDE [sssql16-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 2022 | sssql22-md.md | [!INCLUDE [sssql22-md](../includes/sssql22-md.md)] |
SQL Server 2022 (16.x) |
SQL Server 2025 | sssql22-md.md | [!INCLUDE [sssql25-md](../includes/sssql25-md.md)] |
SQL Server 2025 (17.x) 预览版 |
SQL Server vNext | sssql22-md.md | [!INCLUDE [sssql22-md](../includes/sssql22-md.md)] |
SQL Server 2022 (16.x) |
SQL Server 适用范围(不特定于版本)
这些 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)] |
适用于: |
appliesto-ss-asdb-xxxx-pdw-md.md | [!INCLUDE [appliesto-ss-asdb-xxxx-pdw-md.md](../includes/appliesto-ss-asdb-xxxx-pdw-md.md)] |
适用于: |
appliesto-ss-asdb-xxxx-xxx-md.md | [!INCLUDE [appliesto-ss-asdb-xxxx-xxx-md.md](../includes/applies-to-version/sql-asdb.md)] |
适用于: |
applies-to-version/sql-asdbmi.md | [!INCLUDE [applies-to-version/sql-asdbmi.md](../includes/applies-to-version/sql-asdbmi.md)] |
适用于: |
appliesto-ss-xxxx-asdw-pdw-md.md | [!INCLUDE [appliesto-ss-xxxx-asdw-pdw-md.md](../includes/appliesto-ss-xxxx-asdw-pdw-md.md)] |
适用于: |
appliesto-ss-xxxx-xxxx-pdw-md.md | [!INCLUDE [appliesto-ss-xxxx-xxxx-pdw-md.md](../includes/appliesto-ss-xxxx-xxxx-pdw-md.md)] |
适用于: |
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)] |
适用于: |
applies-to-version/_ssnoversion.md | [!INCLUDE [applies-to-version/_ssnoversion.md](../includes/applies-to-version/sqlserver.md)] |
适用范围: |
appliesto-xx-asdb-asdw-xxx-md.md | [!INCLUDE [appliesto-xx-asdb-asdw-xxx-md.md](../includes/appliesto-xx-asdb-asdw-xxx-md.md)] |
适用于: |
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 适用范围(特定于版本)
这些 applies-to include 文件指定文档适用的 SQL 版本。
文件名 | markdown 示例 | 映像 |
---|---|---|
适用于版本/asa-pdw.md | [!INCLUDE [applies-to-version/asa-pdw.md](../includes/applies-to-version/asa-pdw.md)] |
适用于: |
appliesto-ss-asdb-asdw-xxx-md.md | [!INCLUDE [appliesto-ss-asdb-asdw-xxx-md.md](../includes/appliesto-ss-asdb-asdw-xxx-md.md)] |
适用于: |
appliesto-ss-asdb-xxxx-pdw-md.md | [!INCLUDE [appliesto-ss-asdb-xxxx-pdw-md.md](../includes/appliesto-ss-asdb-xxxx-pdw-md.md)] |
适用于: |
appliesto-ss-asdb-xxxx-xxx-md.md | [!INCLUDE [appliesto-ss-asdb-xxxx-xxx-md.md](../includes/appliesto-ss-asdb-xxxx-xxx-md.md)] |
适用于: |
appliesto-ss-xxxx-asdw-pdw-md.md | [!INCLUDE [appliesto-ss-xxxx-asdw-pdw-md.md](../includes/appliesto-ss-xxxx-asdw-pdw-md.md)] |
适用于: |
appliesto-ss-xxxx-xxxx-pdw-md.md | [!INCLUDE [appliesto-ss-xxxx-xxxx-pdw-md.md](../includes/appliesto-ss-xxxx-xxxx-pdw-md.md)] |
适用于: |
适用于-ss2016-asdb-asdw-pdw-md.md | [!INCLUDE [appliesto-ss2016-asdb-asdw-pdw-md.md](appliesto-ss2016-asdb-asdw-pdw-md.md)] |
适用于: |
appliesto-xx-asdb-asdw-xxx-md.md | [!INCLUDE [appliesto-xx-asdb-asdw-xxx-md.md](../includes/appliesto-xx-asdb-asdw-xxx-md.md)] |
适用于: |
appliesto-xx-asdb-xxxx-xxx-md.md | [!INCLUDE [appliesto-xx-asdb-xxxx-xxx-md.md](../includes/appliesto-xx-asdb-xxxx-xxx-md.md)] |
适用于: |
sqlserver2017-asdb.md | [!INCLUDE [sqlserver2017-asdb.md](../includes/applies-to-version/sqlserver2017-asdb.md)] |
适用于: |
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)] |
适用于: |
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)] |
适用于: |
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)] |
适用于: |
tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md | [!INCLUDE [tsql-appliesto-ss2008-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver.md)] |
适用范围: |
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)] |
适用于: |
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)] |
适用于: |
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)] |
适用于: |
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)] |
适用于: |
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)] |
适用于: |
tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md | [!INCLUDE [tsql-appliesto-ss2017-xxxx-xxxx-xxx-md.md](../includes/applies-to-version/sqlserver2017.md)] |
适用于: |
Analysis Services 适用范围
这些 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 |
ssas-appliesto-sql2016-later.md | [!INCLUDE [ssas-appliesto-sql2016-later.md](../includes/ssas-appliesto-sql2016-later.md)] |
适用于:✅ SQL Server 2016 (13.x) Analysis Services 及更高版本 |
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 及更高版本 |
ssas-适用于-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)] |
适用于: |
ssas-适用于-sqlas-所有-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 include 文件用于 Reporting Services 文档。
文件名 | markdown 示例 | 映像 |
---|---|---|
SQLServerReportingServices-适用于2017及更高版本.md | [!INCLUDE [ssrs-appliesto-2017-and-later.md](../includes/ssrs-appliesto-2017-and-later.md)] |
|
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)] |
|
ssrs-appliesto-sharepoint-2013-2016.md | [!INCLUDE [ssrs-appliesto-sharepoint-2013-2016.md](../includes/ssrs-appliesto-sharepoint-2013-2016.md)] |
|
ssrs-appliesto-sql2016-preview.md | [!INCLUDE [ssrs-appliesto-sql2016-preview.md](../includes/ssrs-appliesto-sql2016-preview.md)] |
适用于: |