Use SQL Data Generator using SQL statement

LRhoLRho Posts: 4 New member
in SQL Data Generator
Can you use SQL Data Generator by writing a SQL statement?  If so, how?
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,736 Rose Gold 5
    Hi,
    Yes you can use a SQL Statement.

    Select the column you wish to generate the SQL Statement upon.  The column generation settings will appear.  Select the Generator drop down and change from the default generator selected to SQL Statement listed under the Generic heading, as per the screen shot below.



    Next enter the SQL Source connection details and finally type in the SQL statement to select a column with a matching data type.


    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
    · Share on Twitter
Sign In or Register to comment.