Browse by Tags

All Tags » Implicit conversion » T-sql (RSS)

Beware of Implicit conversions

Sometimes you may wonder why integer divisions are not giving exact result Consider this example Select 3/4 Select 4/3 Because both numerator and denominators are INTegers, results 0.75, 1.3333 are truncated to integers resulting 0 and 1 respectively...