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

In the beginning...

Why a blog? Well, all testers that matters seems to have one so I better join the crowd. Will be blogging mainly about software testing.