how to set to a variable

• sqlfriend

  SSC Guru

  Points: 52781

  More actions

  May 3, 2023 at 11:55 pm

  Go to Answer

  #4183832

  how can I make SELECT SERVERPROPERTY('MachineName')  to set to a variable?

  Thanks,

• pietlinden

  SSC Guru

  Points: 63503

  More actions

  May 4, 2023 at 1:21 am

  Answer

  #4183854

  Google-fu not working? See this page...

  use tempdb;
  go
  DECLARE @MyMachine NVARCHAR(128);
  SELECT @MyMachine = CAST(SERVERPROPERTY('MachineName') AS NVARCHAR(128))
  PRINT @MyMachine + ' is a piece of junk';