Getting Rows in a Table in Random Order in MS SQL

212 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 are Wait Types in SQL Server ?

What is Change Data Capture in SQL Server ?

What are Indexed Views inside SQL Server ?

Deleting Table With Query in MS SQL

What is Central Management in SQL Server ?