Tuesday, March 23, 2010

TABLESAMPLE

Do you know TABLESAMPLE in SQL Server 2005?
Assume that your tblEmployee in SQL Server 2005 table contains more than 10 records.
Which querie(s) below return exact 10 records?
1. SELECT EmployeeID, EmployeeName
FROM tblEmployee TABLESAMPLE (10 ROWS)
2. SELECT TOP 10 EmployeeID, EmployeeName
FROM tblEmployee

A. Query 1
B. Query 2
C. Both queries
D. No query return exact 10 records

Answer:[B]
Highlight to find out the answer.

No comments:

Post a Comment