Options
smallmoney Preview Inconsistent with Actual Generation
taborro
Posts: 3
Hi, I have a column that is smallmoney. In SQL Data Generator 3 the preview shows nice amounts with two digits after the decimal point. (Example: $111.13) Great!
When the data is actually generated, however, four digits are displayed after the decimal point (Example: $111.1278) which while technically acceptable for a smallmoney datatype, it is not desirable when you need dummy data for a product's price.
Is there any way to tweak this in the tool?
When the data is actually generated, however, four digits are displayed after the decimal point (Example: $111.1278) which while technically acceptable for a smallmoney datatype, it is not desirable when you need dummy data for a product's price.
Is there any way to tweak this in the tool?
Comments