Assignment Operator

I am going to continue the series of very short articles or tidbits on Transaction SQL Operators. An operator is a symbol specifying an action that is performed on one or more expressions. I will exploring the Assignment Operator today. This equality symbol = in mathematics. There are two ways in which the assignment operator can be used: alias – associating a column heading with a expression or storage – placing the results of a expression into a variable. The TSQL example below compares the assignment operator against old and…