Customiz precision for float columns

Compares and synchronizes SQL database content.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong

Customiz precision for float columns

Postby nteelesh » Sat Jun 14, 2014 5:44 pm

SQL Data Compare compares float columns up to 15 places by default. Is it possible if we can use custom precision e.g. up to 8 places?

If it's possible, can some one point me out should I proceed to achieve this.

Any pointers will be helpful.
nteelesh
 
Posts: 1
Joined: Fri Jun 13, 2014 5:59 pm

Postby Brian Donahue » Mon Jun 16, 2014 11:18 am

There is one option for precision in SQL Data Compare... an option called \"use maximum precision for floats\" is available that will take the precision to 17 to be inline with SQL Server.

There is no option to decrease the precision.
Brian Donahue
 
Posts: 6668
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Data Compare 10

Who is online

Users browsing this forum: No registered users and 0 guests