Home Forums Article Discussions Article Discussions by Author Discuss content posted by Mike Tanner Five percent rounded down RE: Five percent rounded down
palotaiarpad
SSCertifiable
Points: 5617
More actions
October 24, 2012 at 12:59 am
#1552144
Lets play a bit:
Select cast(100 as real) * 1.05,cast(cast(100 as real) * 1.05 as int);
-- Result is 105, 104
The result is very strange for me. Does SQL Server the calculation from inside to outside or not? :w00t: