Tuesday, 22 May 2007

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
from mytable

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...

No comments: