Microsoft® SQL Server 2012 Unleashed

Conditional Statements

Often in scripting, some kind of decision must be made by comparing values before a script or set of commands continues.

Operators can provide a simple example of how conditional statements work, as shown here:

Click here to view code image

PS>if("userA" -eq "userA")>> {>>   Write-Host "Equal">> }>> else>> {>>   Write-Host "Not equal">> }>>EqualPS>$user="userB"PS>if("userA" -eq "$user")>> {>>   Write-Host "Equal">> }>> else>> {>>   Write-Host "Not equal">> }>>Not equalPS>

The preceding code provides a simple example and shows how interactive the PowerShell console can be. The >> character is simply PowerShell informing the user that the commands entered are basically not complete, and more input is required.

A later example ...