Operators are symbols that indicate that a specific action is to take place with one or more expressions. A great number of operators are available in SQL Server. Operators are divided into several categories, based on the operations they perform:
This operator—the equal sign (=)—is one of the most ubiquitous operators that you will run into. The assignment operator assigns a value to a variable or a column. An example of this is as follows:
SELECT @intValue = 1
Arithmetic operators are the same simple operations that you learned in grade school to add, subtract, multiple and divide numbers. These operators are used ...