Getting Rows in a Table in Random Order in MS SQL

186 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 Views in MS SQL Database

How to Rebuild the Master Database in SQL Server ?

What is the Use of DBCC Commands in SQL Server ?

What are the Limitations of Indexed Views in SQL Server ?

How is Sqlcmd Different from Osql ?