I need to update a Database. The database tables uses float. Must be changed to decimal(18,6). I can change the Column definitions and SP parameters, but, underlining application (C# and/or
VB.NET) will still have parameters defined as SqlDbType.Float. I tried and it worked without changing the application. Is it reliable? Does the float accuracy problem gets resolved?
Tkx for the reply, There is an aditional problem: the conversion decimal <-> float (double) is not implicit and errors may occur. The app will have to be updated. No way around it. So the question no longer makes sense.