Randomize test data

Random test data could be a good thing in certain situations in software testing.

If your AUT (application under test) is running on MS SQL Server there is a smart function in

order by newid()

By using this the record set will sorted randomly.

To get one record randomly syntax will be

select top 1
mydata
from mytable
where
mydata = mytestdatarequirement
order by newid()

With this you can easily build small web apps. for testing using vbScript and/or JavaScript. More about that later...