Browse by Tags

• T-SQL

Beware of Implicit conversions
16 January 08 12:42 PM | Madhivanan | 2 Comments   

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 Read More...

Filed under: sql server, T-SQL, Implicit conversion