get sql server to warn about truncation / rounding

flippindog

New Member
I am working on an ASP.NET C# accounting app and I am in the transition from using floats/doubles to using decimals to represent money.Now I want to control when and where rounding takes place.The way I understand it, SQL server rounds decimal data types differently than C# does.Is there some way to get SQL server (2008) to warn or fail if decimal values (or any kind of data) are getting truncated or rounded?Thanks,
 
Top