# / (Divide) (TSQL Operator)

Divides one number by another number.

### Syntax

```
expression / expression
```

### Arguments

- expression
- is a numeric expression of type
`tinyint`

,`smallint`

,`int`

,`bigint`

,`money`

,`numeric`

,`float`

.

### Return Types

Returns the datatype of the *expression* with the highest type precedence.

### Remarks

If both *expressions* are integer numbers, an integer division is performed, which truncates the result to integer type.

If divisor is 0, an error is raised.

### Examples

```
-- integer division, because both operands are integers
PRINT 123 / 50;
-- numeric division, because first operand is numeric type, and it has highest type precedence.
PRINT 123. / 50; -- second operand is cast to numeric type, and result is numeric type
-- float division, because first operand is float type, and it has highest type precedence.
PRINT 123.e0 / 50; -- second operand is cast to float type, and result is float type
-- varchar is converted to int, because int has highest type precedence
PRINT '123' / 50;
```

The result is:

```
2
2.460000000000
2.46
2
```

### Example division by 0

```
PRINT 123.45 / 0;
```

The result is:

```
<Arithmetic error. NUMERIC division by zero.>
```