Monday, May 31, 2010

Random Data Sampling Queries in SQL Server 2005

The following query will return a random sampling of data:


SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (1 PERCENT);
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (100 PERCENT);


SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (20 ROWS)
SELECT * FROM PHTTEMPORDERSHEET TABLESAMPLE SYSTEM (200 ROWS)


Not only will the records returned be random, but so will the number of rows.

No comments:

Post a Comment