Microsoft® SQL Server 2012 Unleashed

Creating a PowerShell Script

Creating a PowerShell script is as simple as placing a few commands into a .ps1 script and then invoking that script. Here’s a simple example of putting the Write-Host cmdlet into a script and then running it.

Click here to view code image

PS> add-content c:\temp\test.ps1 "Write-Host `testing`"PS>c:\temp\test.ps1testingPS>

In the preceding example, a Write-Host cmdlet was placed in a file named test.ps1, and then the file was invoked. The output resulted in the string "testing" being output to the script.

You can use any text editor to create more complicated scripts or you can use the PowerShell Integrated Scripting Environment (ISE). The PowerShell ISE is a powerful tool that enables you to create and run PowerShell ...