Thursday, March 11, 2010

How to select random rows in SQL Server

In SQL Server its simple, just use order by newid()

Select * from tableName order by newid()

No comments:

Post a Comment