Get records in random order from a sql query in sql server.

Check this in SQL Server, we can get records in random order from a sql query using NEWID( ) Function.

Like:

SELECT Name FROM UserDetail ORDER BY NEWID( )

  

Enjoy programming.......

Next Recommended Reading Data types in SQL Server 2000