SQL Server Assignment Operator (=)

There is only one assignment operator and that is "=". This is used to assign a value to some expression.

DECLARE @AnExpression INT; SET @AnExpression = 87;