O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required