Fichiers include SQL Server pour la gestion des versions et applies-to

Les références de la documentation peuvent être facilement modifiées sans changer le texte des articles individuellement en utilisant des fichiers include dans Markdown. Il existe trois types de fichiers include dans le contenu SQL : versions SQL, applies-to et texte de référence. Les fichiers include de version SQL sont utilisés pour indiquer la version de SQL concernée, comme SQL Server 2016 ou 2017. Les fichiers include applies-to indiquent les services et produits SQL auquel s’applique le document, comme SQL Server sur Linux ou Azure SQL Database. Les fichiers include de texte de référence ne font pas partie des deux autres catégories, comme le fichier include « Get Help », qui est une liste de liens que les clients peuvent utiliser pour obtenir de l’aide sur SQL Server.

Cet article est destiné à être utilisé comme point de référence pour les deux premiers types de fichiers include. Vous pouvez parcourir la liste complète des fichiers include dans le dépôt sql-docs.

Fichiers include de version SQL Server

Les rédacteurs de contenu SQL ont souvent besoin d’inclure le nom du produit et de la version de SQL Server. De cette façon, si quelque chose change dans le nom, le fichier include est mis à jour au lieu de mettre à jour manuellement la valeur dans chacun des articles. Ces fichiers include sont utilisés comme espaces réservés pour les noms de produit, mais n’ont pas été utilisés de manière cohérente dans toute la documentation SQL. SQL Server vNext fait référence à une version future de SQL qui n’a pas encore d’un numéro de version et fait exception à cela.

Version SQL Nom de fichier Exemple dans Markdown Texte
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)

Applies-to dans SQL Server (non spécifique à une version)

Ces fichiers include applies-to omettent la version de SQL Server.

Nom de fichier Exemple dans Markdown Image
appliesto-ss-asdb-asdw-xxx-md.md [!INCLUDE[SQL Server ASDB, ASDBMI, ASDW](../includes/applies-to-version/sql-asdb-asdbmi-asa.md)] S’applique à :SQL ServerAzure SQL DatabaseAzure SQL Managed InstanceAzure 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)] S’applique à : SQL Server Azure SQL Database Not supported. 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)] S’applique à :SQL ServerAzure SQL Database
applies-to-version/sql-asdbmi.md [!INCLUDE[applies-to-version/sql-asdbmi.md](../includes/applies-to-version/sql-asdbmi.md)] S’applique à :SQL ServerAzure SQL Managed Instance
appliesto-ss-xxxx-asdw-pdw-md.md [!INCLUDE[appliesto-ss-xxxx-asdw-pdw-md.md](../includes/appliesto-ss-xxxx-asdw-pdw-md.md)] S’applique à : SQL Server Not supported. Azure SQL Database 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)] S’applique à : SQL Server Not supported. Azure SQL Database Not supported. 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)] S’applique à : SQL Server (Windows uniquement) Not supported. Azure SQL DatabaseNot supported. Azure Synapse Analytics Not supported. Analytics Platform System (PDW)
applies-to-version/_ssnoversion.md [!INCLUDE[applies-to-version/_ssnoversion.md](../includes/applies-to-version/sqlserver.md)] S’applique à :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)] S’applique à :Not supported. SQL Server Azure SQL Database Azure Synapse Analytics Not supported. 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)] S’applique à :Not supported. SQL Server Azure SQL Database Not supported. Azure Synapse Analytics Not supported. Analytics Platform System (PDW)

Applies-to dans SQL Server (spécifique à la version)

Ces fichiers include applies-to indiquent les versions de SQL auxquelles s’applique la documentation.

Nom de fichier Exemple dans Markdown Image
applies-to-version/asa-pdw.md [!INCLUDE[applies-to-version/asa-pdw.md](../includes/applies-to-version/asa-pdw.md)] S’applique à : Azure Synapse AnalyticsAnalytics 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)] S’applique à : SQL Server Azure SQL Database Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server Azure SQL Database Not supported. 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)] S’applique à : SQL Server Azure SQL Database Not supported. Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server Not supported. Azure SQL Database 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)] S’applique à : SQL Server Not supported. Azure SQL Database Not supported. 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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Base de données 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)] S’applique à :Not supported. SQL Server Azure SQL Database Azure Synapse Analytics Not supported. 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)] S’applique à :Not supported. SQL Server Azure SQL Database Not supported. Azure Synapse Analytics Not supported. Analytics Platform System (PDW)
sqlserver2017-asdb.md [!INCLUDE[sqlserver2017-asdb.md](../includes/applies-to-version/sqlserver2017-asdb.md)] S’applique à : SQL Server 2017 (14.x) et versions ultérieuresAzure SQL Database
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)] S’applique à : SQL Server 2014 Azure SQL Database Not supported. Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server 2016 (13.x) SP 2 et versions ultérieures Base de données Azure SQL Not supported. Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server Azure SQL Managed Instance Not supported. 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)] S’applique à :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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Base de données Azure SQL Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Base de données Azure SQL Not supported. Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Not supported. Base de données 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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Not supported. Base de données Azure SQL Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server 2016 (13.x) et versions ultérieures Not supported. Base de données Azure SQL Not supported. Azure Synapse Analytics Not supported. 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)] S’applique à : SQL Server 2017 (14.x) et versions plus récentes

Applies-to dans Analysis Services

Ces fichiers include applies-to sont utilisés avec la documentation Analysis Services.

Nom de fichier Exemple dans Markdown Image
ssas-appliesto-sql2016.md [!INCLUDE[ssas-appliesto-sql2016.md](../includes/ssas-appliesto-sql2016.md)] S’applique à : SQL Server 2016 (13.x) Analysis Services Not supported. Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sql2016-later.md [!INCLUDE[ssas-appliesto-sql2016-later.md](../includes/ssas-appliesto-sql2016-later.md)] S’applique à : SQL Server 2016 (13.x) Analysis Services et versions ultérieures Not supported. Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sql2016-later-aas.md [!INCLUDE[ssas-appliesto-sql2016-later-aas.md](../includes/ssas-appliesto-sql2016-later-aas.md)] S’applique à : SQL Server 2016 (13.x) Analysis Services et versions ultérieures Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sql2017.md [!INCLUDE[ssas-appliesto-sql2017.md](../includes/ssas-appliesto-sql2017.md)] S’applique à : SQL Server 2017 Analysis Services Not supported. Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sql2017-later-aas.md [!INCLUDE[ssas-appliesto-sql2017-later-aas.md](../includes/ssas-appliesto-sql2017-later-aas.md)] S’applique à : SQL Server 2017 Analysis Services et ultérieur Azure Analysis Services Not supported. Power BI Premium
ssas.md [!INCLUDE[ssas.md](../includes/applies-to-version/ssas.md)] S’applique à :SQL Server Analysis Services
ssas-appliesto-sqlas-all-aas.md [!INCLUDE[ssas-aas.md](../includes/ssas-appliesto-sqlas-all-aas.md)] S’applique à : SQL Server Analysis Services Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sqlas-all.md [!INCLUDE[ssas-all.md](../includes/ssas-appliesto-sqlas-all.md)] S’applique à : SQL Server Analysis Services Not supported. Azure Analysis Services Not supported. Power BI Premium
ssas-appliesto-sqlas-all-aas.md [!INCLUDE[ssas-all-aas.md](../includes/ssas-appliesto-sqlas-all-aas.md)] S’applique à : SQL Server Analysis Services Azure Analysis Services Not supported. Power BI Premium

Applies-to dans Reporting Services

Ces fichiers include applies-to sont utilisés avec la documentation Reporting Services.

Nom de fichier Exemple dans Markdown Image
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 et ultérieur)
ssrs-appliesto-not-pbirs.md [!INCLUDE[ssrs-appliesto-not-pbirs.md](../includes/ssrs-appliesto-not-pbirs.md)] Not supported Power BI Report Server
ssrs-appliesto-pbirs.md [!INCLUDE[ssrs-appliesto-pbirs.md](../includes/ssrs-appliesto-pbirs.md)] Serveur de rapports Power BI Report Server
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)] S’applique à : SQL Server 2016 (13.x) Power BI Report Server

Étapes suivantes

Pour plus d’informations sur l’utilisation de ces fichiers include, consultez Fichiers include applies-to.