Selecting Rows Randomly from a Large Table
http://msdn.microsoft.com/en-us/library/cc441928.aspx
语句如下:
SELECT * FROM Table1 WHERE (ABS(CAST( (BINARY_CHECKSUM (keycol1, NEWID())) as int)) % 100) < 10
select top 1 * from Table1 TABLESAMPLE(1000 ROWS)