Microsoft® SQL Server 2008 R2 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:

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 using the AdventureWorks2008R2 database uses a conditional statement to make a particular decision based on the results from evaluating a particular expression. ...