What are the challenges you face when working across database platforms? Take the survey

smallmoney Preview Inconsistent with Actual Generation

taborrotaborro Posts: 3
edited September 25, 2014 5:13PM in SQL Data Generator
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?


  • Options
    I must have posted in the wrong place ... I would have expected an answer now if this was monitored by redgate employees / support staff. Could someone please advice? Thank you!
Sign In or Register to comment.