Microsoft SQL Server 2008 Bible

Overview

Operators in SQL are defined as symbols and keywords that are used to specify an action to be performed on one or more expression called operands or arguments.

There are two general types of operators

• Unary Operators. Applied to only one operand at the time; the typical format is <operator><operand>.

• Binary Operators. Applied to two operands at the time; they usually appear in format <operand><operator><operand>.