Getting Rows in a Table in Random Order in MS SQL

35 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

Getting List of All Server Databases in MS SQL

What is the Maximum Number of Columns a Table in SQL Server ?

What is a Control Flow Inside SSIS ?

What is Auditing Inside SQL Server ?

Disable All Triggers in MS SQL Server Table