CODEWITHSUNDEEP
sqlsql-server-2000
born to hula
born to hula

Reputation: 1286

SQL Server 2000 Integer truncating

Plain and simple, does anybody know why this:

Select 30 * 220 / 30

Returns 220, which is the correct result, and this:

Select 30 * (220/30)

Returns 210???

On the second case, I realise that 220/30 is being calculated first, generating a decimal (7,333333...) but still... isn't this lousy precision?

Upvotes: 1

Views: 114

Answers (2)

Martin Smith
Martin Smith

Reputation: 453910

Under integer division 220/30 = 7 and 99/100 = 0 (note truncation not rounding)

Use non integers to avoid this. e.g. Select 30 * (220/30.0)

Or you can use an explicit cast

Select 30 * (220/cast (30 as float))

Upvotes: 4

Carlos Valenzuela
Carlos Valenzuela

Reputation: 834

The one in the parentheses, is always evaluated first, but since the machine logic you are using integer, in that case, the result of the division is 7, wich you multiply by 30, gives you 210

Upvotes: 1

Related Questions