Recent Posts

News

Navigation

Archives

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)

תגים:story/Tip, DEV

Comments

Shlomo said:

נחמד מאוד

# March 18, 2009 7:40 PM

Leave a Comment

Title (required)

Name (required)

Your URL (optional)

Comments (required)

Remember Me?

Enter the numbers above: