Generate data for derived column

Greetings,

I need to populate test data for certain columns which are derived from other columns in the same table. What is the best way to do this?

For example, I have a column that is derived by concatenating the values of 7 other columns in the same table.

Thanks,

SB

sbendayan March 13, 2017 09:33

Comments

1 comment

Thanks for contacting us!
It might be better to use a Computed Column instead of SQL Data Generator- Data Generator cannot do single column generation - it does whole rows.
https://msdn.microsoft.com/en-us/library/ms188300.aspx
If you do want to generate new rows, or delete the current records and insert new ones, then you can concatenate like that using the "Simple expression generator" https://documentation.red-gate.com/display/SDG3/Generic+generators

Do let me know if you have any questions or issues with that!

Warm Regards,

Andrew P March 15, 2017 20:29

0

Add comment

Please sign in to leave a comment.

How can we help you today?

Generate data for derived column

Comments

Add comment