May 5, 2015 – Knowledgebase

drop and create SQL Server tables based on an array with table names by using PowerShell

5 May, 2015 Roel van Lisdonk 0 Comments Uncategorized

# Add table names to the "$tables" array in the order they should be created. $tables = @( "dbo.Person", "dbo.Settings", "dbo.SmsStatus", "dbo.Sms" ) # Create a table if it does not exist. # It

Use formatting–f, when writing to the output console with PowerShell

5 May, 2015 Roel van Lisdonk 0 Comments Uncategorized

If you want to format a string when echoing to the screen, use parentheses. Echo("This is {0} " -f "a test.") Will output: This is a test. Note http://stackoverflow.com/questions/17623644/what-is-the-difference-between-echo-and-write-host-in-powershell echo is an alias

Day: May 5, 2015

drop and create SQL Server tables based on an array with table names by using PowerShell

Use formatting–f, when writing to the output console with PowerShell