Use a Variable in Select statement

• itpcpro

  Ten Centuries

  Points: 1043

  More actions

  August 26, 2011 at 10:45 am

  #256263

  Ok.. Here is what I have:

  I am using: foreach ($SqlServer in get-content "F:\Powershell_Apps\Zero_Data_Tables\SQL_Servers.txt")

  To get all of my Sql Servers that I need to search each database..

  My connection is: $con = "server=$SqlServer;database=DBName;Integrated Security=sspi"

  My query is: $SqlQuery = "select $SqlServer,DatabaseName,TableName,Rows from Zero_Data_Tables"

  But it is not liking the $SqlServer so if I take it out it works fine...

  Any suggestions...

• itpcpro

  Ten Centuries

  Points: 1043

  More actions

  August 26, 2011 at 1:10 pm

  #1374061

  I found a solution...

  $SqlQuery = "select " + $SqlServer + ",DatabaseName,TableName,Rows from Zero_Data_Tables"