Microsoft® SQL Server 2008 R2 Unleashed

Variables

Strings and objects were discussed earlier in this chapter. A very 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:

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

The Read-Host ...