You can sort a Table Randomly with a single keyword.
the newsid() is the keyword which generates a random number in sql server.
Here is small ex.
1)Create a database
2)Create Table Master
3)Create Fields Code nvarchar(50), Name Nvarchar(50)
4)Enter some data into table
5)Now open new query window
6)Write sql
7)Select * from Master Order by newid()
Now, run this code it will return data in random format.
You can also use newid() to generate a unique number or a number like verification code etc.
for ex.
Select newid()
Randomly Sort Sql server Table
![](http://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjdFOQN1NfH5bq8tt8j1unZFJ2EcPEQShAK4-Sp7v27n8TZEbXVXpRwcjyOm5sNJkzm0VBClpM6dbXDN7l0ZI6c3q1CoTvDlaYuwU8ztVPhyxw2vfCOuVTwDRW2Pj5HBg/s220/logo.jpg)
No comments:
Post a Comment