Toad for SQL Server 184.108.40.2063.
Today I try to generate random datas for my table.
Table is a simple table.
This is the script :
CREATE TABLE dbo.Price (
ProductID INT PRIMARY KEY,
LastUpdate DATE NOT NULL,
Price SMALLMONEY NULL,
I open TOOLS - DATA GENERATOR, connect my DB and table and I try to pump/generate datas in it.
I attach a screenshot for details :
I obtain a lot of errors on field - PRICE - . Type of it is : Overflow of value.
As you can see price field is of type smallmoney and your tool set maximum and minimum range of data correctly, minimum : -214748.3648 and mximum : 214748.3647.
But if you analize the value in the bottom of the window - preview of generated data first 1000 rows - you can see for example, line 4 : 46235357, line 8 : 804436644, etc,etc,.. is not in the range and this generate the problem.
Values generated is 1000 and if I analyze the data I fond a lot of errors.
The same problem is present in the last BETA Toad for SQL Server Beta 220.127.116.11.
Can you correct this problem please ?