sql server updgration

SELECT

SERVERPROPERTY('ServerName') 'ServerName'

,@@VERSION '@@version'

,SERVERPROPERTY('ComputerNamePhysicalNetBIOS') 'ComputerNamePhysicalNetBIOS'

,SERVERPROPERTY('MachineName') 'MachineName'

,SERVERPROPERTY('InstanceName') 'InstanceName'

,SERVERPROPERTY('IsClustered') 'IsClustered'

,SERVERPROPERTY('BuildClrVersion') 'BuildClrVersion'

,SERVERPROPERTY('Collation') 'Collation'

,SERVERPROPERTY('CollationID') 'CollationID'

,SERVERPROPERTY('ComparisonStyle') 'ComparisonStyle'

,SERVERPROPERTY('ComputerNamePhysicalNetBIOS') 'ComputerNamePhysicalNetBIOS'

,SERVERPROPERTY('Edition') 'Edition'

,SERVERPROPERTY('EditionID') 'EditionID'

,SERVERPROPERTY('EngineEdition') 'EngineEdition'

,SERVERPROPERTY('IsFullTextInstalled') 'IsFullTextInstalled'

,SERVERPROPERTY('IsIntegratedSecurityOnly') 'IsIntegratedSecurityOnly'

,SERVERPROPERTY('IsSingleUser') 'IsSingleUser'

,SERVERPROPERTY('LCID') 'LCID'

,SERVERPROPERTY('LicenseType') 'LicenseType'

,SERVERPROPERTY('NumLicenses') 'NumLicenses'

,SERVERPROPERTY('ProcessID') 'ProcessID'

,SERVERPROPERTY('ProductVersion') 'ProductVersion'

,SERVERPROPERTY('ProductLevel') 'ProductLevel'

,SERVERPROPERTY('ResourceLastUpdateDateTime') 'ResourceLastUpdateDateTime'

,SERVERPROPERTY('ResourceVersion') 'ResourceVersion'

,SERVERPROPERTY('ServerName') 'ServerName'

,SERVERPROPERTY('SqlCharSet') 'SqlCharSet'

,SERVERPROPERTY('SqlCharSetName') 'SqlCharSetName'

,SERVERPROPERTY('SqlSortOrder') 'SqlSortOrder'

,SERVERPROPERTY('SqlSortOrderName') 'SqlSortOrderName'

,SERVERPROPERTY('FilestreamShareName') 'FilestreamShareName'

,SERVERPROPERTY('FilestreamConfiguredLevel') 'FilestreamConfiguredLevel'

,SERVERPROPERTY('FilestreamEffectiveLevel') 'FilestreamEffectiveLevel'