Comparing numeric types to other datatypes

When comparing numeric and decimal columns to columns of other numeric datatypes, such as money or int:

The precision and scale of integer and money types is shown in Table 19-3.

Table 19-3: Precision and scale of integer and money types

Datatype

Precision, scale

tinyint

3,0

smallint

5,0

int

10,0

smallmoney

10,4

money

19,4