Getting Rows in a Table in Random Order in MS SQL

200 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

What is FILLFACTOR in SQL Server ?

Generating Random Letters in MS SQL

How is Change Tracking is Different From Change Data Capture ?

What are OFFLINE Datafiles with SQL Server ?

What is Blocking in SQL Server ?