2556-05-28

table sample percent sql server

The rows retrieved are random and they are are not in any order
Example 1:
SELECT FirstName,LastNameFROM Person.Contact
TABLESAMPLE SYSTEM 
(10 PERCENT)

Example 2:
SELECT FirstName,LastNameFROM Person.Contact
TABLESAMPLE SYSTEM 
(1000 ROWS)


http://blog.sqlauthority.com/2007/05/27/sql-server-2005-limiting-result-sets-by-using-tablesample-examples/

ไม่มีความคิดเห็น:

แสดงความคิดเห็น