Différences entre les versions de « Mssql »
De BlaxWiki
Aller à la navigationAller à la recherche (Page créée avec « Voilà une liste de commande mssql permettant d'avoir des informations précises sur la version, service pack.... de mssql <pre> SELECT @@VERSION SELECT Serverproperty('Ed... ») |
|||
| Ligne 6 : | Ligne 6 : | ||
SELECT Serverproperty('ProductVersion') as SQLServer_Version | SELECT Serverproperty('ProductVersion') as SQLServer_Version | ||
SELECT Serverproperty('InstanceName') as SQLServer_Instance | SELECT Serverproperty('InstanceName') as SQLServer_Instance | ||
SELECT SERVERPROPERTY('Collation') AS 'Collation' | |||
SELECT Serverproperty('Collation') as SQLServer_Collation | SELECT Serverproperty('Collation') as SQLServer_Collation | ||
SELECT Serverproperty('IsClustered') as SQLServer_IsClustered | SELECT Serverproperty('IsClustered') as SQLServer_IsClustered | ||
SELECT Serverproperty('IsFullTextInstalled') as SQLServer_IsFullTextInstalled | SELECT Serverproperty('IsFullTextInstalled') as SQLServer_IsFullTextInstalled | ||
SELECT Serverproperty('IsIntegratedSecurityOnly') as | SELECT Serverproperty('IsIntegratedSecurityOnly') as SQLServer_IsIntegratedSecurityOnly | ||
SQLServer_IsIntegratedSecurityOnly | |||
SELECT Serverproperty('LicenseType') as SQLServer_LicenseType | SELECT Serverproperty('LicenseType') as SQLServer_LicenseType | ||
SELECT Serverproperty('ServerName') as SQLServer_ServerName | SELECT Serverproperty('ServerName') as SQLServer_ServerName | ||
</pre> | </pre> | ||
[[Catégorie:Software]] | [[Catégorie:Software]] | ||
Version du 29 juin 2012 à 09:33
Voilà une liste de commande mssql permettant d'avoir des informations précises sur la version, service pack.... de mssql
SELECT @@VERSION
SELECT Serverproperty('Edition') as SQLServer_Edition
SELECT Serverproperty('ProductLevel') as SQLServer_Level
SELECT Serverproperty('ProductVersion') as SQLServer_Version
SELECT Serverproperty('InstanceName') as SQLServer_Instance
SELECT SERVERPROPERTY('Collation') AS 'Collation'
SELECT Serverproperty('Collation') as SQLServer_Collation
SELECT Serverproperty('IsClustered') as SQLServer_IsClustered
SELECT Serverproperty('IsFullTextInstalled') as SQLServer_IsFullTextInstalled
SELECT Serverproperty('IsIntegratedSecurityOnly') as SQLServer_IsIntegratedSecurityOnly
SELECT Serverproperty('LicenseType') as SQLServer_LicenseType
SELECT Serverproperty('ServerName') as SQLServer_ServerName
