Daniel Bowlin (10/13/2010)
Interesting question. I thought all Microsoft software did banker's rounding. Thanks.
It is flexible. CLR procedures in SQL Server, any .NET code can use one of the two MidpointRounding enum values as a mode
parameter value of the of the Math.Round method:
Math.Round(4.5, 0, MidpointRounding.AwayFromZero); -- 5
Math.Round(4.5, 0, MidpointRounding.ToEven); -- 4