Tsql 获取服务器信息

Tsql 获取服务器属性,如服务器版本。服务器名

ref:http://technet.microsoft.com/zh-cn/library/ms174396.aspx

select serverproperty ('servername') 
select serverproperty ('BuildClrVersion');
select serverproperty ('Collation');
select serverproperty ('CollationID');
select serverproperty ('ComparisonStyle');
select serverproperty ('ComputerNamePhysicalNetBIOS');
select serverproperty ('Edition');
select serverproperty ('EditionID');
select serverproperty ('EngineEdition');
select serverproperty ('HadrManagerStatus');
select serverproperty ('InstanceName');
select serverproperty ('IsClustered');
select serverproperty ('IsFullTextInstalled');
select serverproperty ('IsHadrEnabled');
select serverproperty ('IsIntegratedSecurityOnly');
select serverproperty ('IsLocalDB');
select serverproperty ('IsSingleUser');
select serverproperty ('LCID');
select serverproperty ('LicenseType');
select serverproperty ('MachineName');
select serverproperty ('NumLicenses');
select serverproperty ('ProcessID');
select serverproperty ('ProductVersion');
select serverproperty ('ProductLevel');
select serverproperty ('ResourceLastUpdateDateTime');
select serverproperty ('ResourceVersion');
select serverproperty ('ServerName');
select serverproperty ('SqlCharSet');
select serverproperty ('SqlCharSetName');
select serverproperty ('SqlSortOrder');
select serverproperty ('SqlSortOrderName');
select serverproperty ('FilestreamShareName');
select serverproperty ('FilestreamConfiguredLevel');
select serverproperty ('FilestreamEffectiveLevel'); 

  类似<? phpinfo()?> 获取php 服务器信息。

原文地址:https://www.cnblogs.com/senion/p/3614256.html