# = (Assignment) (TSQL Operator)

Assigns the value of an expression to a variable.

### Syntax

```
@variable = expression
@variable += expression is a shortcut for @variable = @variable + expression
@variable -= expression is a shortcut for @variable = @variable - expression
@variable *= expression is a shortcut for @variable = @variable * expression
@variable /= expression is a shortcut for @variable = @variable / expression
@variable %= expression is a shortcut for @variable = @variable % expression
@variable &= expression is a shortcut for @variable = @variable & expression
@variable |= expression is a shortcut for @variable = @variable | expression
@variable ^= expression is a shortcut for @variable = @variable ^ expression
```

### Arguments

- variable
- is a variable of any type.
- expression
- is an expression of any type.

### Remarks

If type of *expression* is not the same as the type of *variable*, an implicit cast is performed.

### Examples

```
DECLARE @a INT;
SET @a = 12345.67; -- the expression of type NUMERIC is implicitly cast to INT
PRINT @a;
SET @a += 40000;
PRINT @a;
```

The result is:

```
12345
52345
```