SQL

• mtz676

  SSCrazy Eights

  Points: 9261

  More actions

  October 15, 2015 at 11:47 am

  #321915

  How can I combine both these in 1 statement

  select Servername = cast(@@servername as varchar(255)),

  Collation = cast(SERVERPROPERTY('Collation')as varchar(255)),

  BuildClrVersion = cast (SERVERPROPERTY('BuildClrVersion') as varchar(255))

  SELECT value

  FROM sys.configurations

  WHERE name = 'backup compression default' ;

  Both the above t-sql work independently.How can I combine both in 1 T-SQL statement

  Thanks

• Michael L John

  One Orange Chip

  Points: 27079

  More actions

  October 15, 2015 at 11:52 am

  #1833581

  SELECT value,

  cast(@@servername as varchar(255)) as Servername,

  cast(SERVERPROPERTY('Collation')as varchar(255)) as Collation,

  cast (SERVERPROPERTY('BuildClrVersion') as varchar(255)) BuildClrVersion

  FROM sys.configurations

  WHERE name = 'backup compression default' ;

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/