Getting Rows in a Table in Random Order in MS SQL

83 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

Listing Metadata of MS SQL Server Internal Tables

What is the Difference Between VARCHAR and VARCHAR(MAX) Datatypes ...

MS SQL Show Only Date of Current Time

Changing Column Name of MS SQL Table with Query

Using MS SQL WHERE