Category Archives: NEWID()

Selecting a random database record with SQL

Here’s a “quick and dirty” way of selecting a database record at random. This can be used for things like showing a featured product or a random advert. Continue reading

Posted in ASP.NET, DataRowView, DataView, NEWID(), SQL, TOP, Uncategorized, VB.NET | Tagged , , , , , , , , , | Comments Off on Selecting a random database record with SQL