Getting Rows in a Table in Random Order in MS SQL

46 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

How is Auditing Different From Change Data Capture in SQL Server?

How to Restart SQL Server in Single-User Mode ?

What is the Difference Between CHAR and VARCHAR Datatypes in SQL ...

Finding Server Default Language in MS SQL

What are Wait Types in SQL Server ?