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:
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:
PS>$database=read-host "Enter a database name"Enter a database name:AdventureWorks2012PS>$databaseAdventureWorks2012 ...
Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.