Getting Rows in a Table in Random Order in MS SQL

43 Reads Ms Sql

In MS SQL Server, the following procedure is followed to randomly fetch all records in a table.

SELECT * FROM {Table Name} ORDER BY NEWID()
Ms Sql

You May Interest

Showing Server Active Server Name in MS SQL

What is the Difference Between a Local and a Global Temporary Tab ...

What is TABLESAMPLE in SQL Server ?

MS SQL Finding Which Tables a Column Name is In

What is NOLOCK Hint in SQL Server ?