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 服务器信息。