DCSIMG
March 2009 - Posts - SQL SERVER DBAces And More

SQL SERVER DBAces And More

שרון כהן שכן טוב

March 2009 - Posts

How to get or sort randomly records

Using randomly records can be benefit for testing two or more application with different data
simply add to the Order by column NEWID()

 SELECT TOP 200 * FROM mytbl ORDER BY NEWID()

 

sharon cohen

 

 

Posted: Mar 18 2009, 12:22 PM by DBASharon | with 1 comment(s)
תגים:,