Hi,
How to return truly random data from a table?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 29, 2012, 10:53 PM
you can done by using random number generator,
http://blog.sqlauthority.com/2007/04/29/sql-server-random-number-generator-script-sql-query/
http://weblogs.sqlteam.com/jeffs/archive/2004/11/22/2927.aspx
hope this help.
Satyapriya NayakPosted Jan 29, 2012, 3:39 AM
Please refer the below link
http://msdn.microsoft.com/en-us/library/cc441928.aspx
Thanks