smallmoney Preview Inconsistent with Actual Generation

The simplest way to populate your database with test data.

smallmoney Preview Inconsistent with Actual Generation

Postby taborro » Fri Aug 29, 2014 6:31 pm

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?
taborro
 
Posts: 2
Joined: Fri Aug 29, 2014 6:26 pm
Location: Dallas, Tx USA

Re: smallmoney Preview Inconsistent with Actual Generation

Postby taborro » Thu Sep 25, 2014 9:13 pm

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!
taborro
 
Posts: 2
Joined: Fri Aug 29, 2014 6:26 pm
Location: Dallas, Tx USA


Return to SQL Data Generator 3

Who is online

Users browsing this forum: No registered users and 0 guests

cron