Hi All,
I need to corrupt some data for demo purposes and need a way to replace the real customer number with a random customer number from my customer table. Sounds simple enough but...
What is the best way to return a random row from a table?
I need this to be quick! There is a lot of records in the table I am
dumping.
Thanks,
Rob
I need to corrupt some data for demo purposes and need a way to replace the real customer number with a random customer number from my customer table. Sounds simple enough but...
What is the best way to return a random row from a table?
I need this to be quick! There is a lot of records in the table I am
dumping.
Thanks,
Rob