Procedure for Random Numbers

Total article views: 510 | Views in the last 30 days: 2

 Rate this |   Join the discussion |  Briefcase

Here is handy procedure to generate random number.
I find it useful when I generate large amount of test data in a database.
For example if you need to create a Customer Data and what they have purchased in the last month to run perfrmance tests on large amount of data an set up necessary indexes.
You can insert records into customer table and put in a random amount for the purchase price or assign a ID of related item id, if Index in the related table is sequential you can put in min(id) and Max(id) get a random item id and Assign it to your customer record.
Also you can use it when ever you need to generate a random number between 2 numbers.

Good Luck
Dan

Total article views: 510 | Views in the last 30 days: 2