Return random rows from a MS SQL database

I always forget this command:

SELECT * FROM YourTable TABLESAMPLE SYSTEM (10 PERCENT)

This gives you some sample data from your database. In this case 10 percent of the content. You could also use TABLESAMPLE SYSTEM (1000 ROWS) to get 1000 sample rows. Great to use if you have a big database and do not want the same data again and again when you debug or something.

This entry was posted on Tuesday, November 17th, 2009 at 13:13 and is filed under SQL. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

3 Responses to “Return random rows from a MS SQL database”

smnbss on November 20th, 2009 at 13:10

Incorrect syntax near the keyword ‘Table’.
Ola on November 26th, 2009 at 10:27

Oh Table is not a keyword. Is wast meant as “myTable” or something!
Bust A Job on January 7th, 2010 at 13:22

Table mean the table name in your database. See more in bustajob.com

Codepolice.net