Microsoft® SQL Server 2012 Unleashed

Variables

Strings and objects were discussed earlier in this chapter. A useful feature of PowerShell, and thus of SQL-PowerShell, is the ability to place objects into a variable. This allows you to run any kind of command and place any objects produced into a variable for later use.

Examples of using variables are presented later in this chapter. For now, a string can be easily saved as a variable:

Click here to view code image

PS>$var="AdventureWorks2012"PS>$varAdventureWorks2012

In the preceding example, the string is saved as the variable $var and then output to the script when the variable is simply invoked:

Click here to view code image

PS>$database=read-host "Enter a database name"Enter a database name:AdventureWorks2012PS>$databaseAdventureWorks2012 ...