Hi experts,
I'm trying out some simple select queries in SQL Server 2008 and I'm testing out the TABLESAMPLE clause.
http://msdn.microsoft.com/en-us/library/ms189108.aspx
I'm using the Adventureworks database.
I'm using the Person.Contact table in the Adventureworks database.
FIrst I tried out the following query (Selecting a percentage of rows) and this query worked just fine.
SELECT FirstName, LastName
FROM Person.Contact
TABLESAMPLE (10 PERCENT);
But then I tried the following query to test (Selecting a number of rows).
When I executed this query the result set I get is blank as shown in the picture below.
SELECT FirstName, LastName
FROM Person.Contact
TABLESAMPLE (4 ROWS);
Does anyone know why the result set is not showing the values for the first 4 rows?
Thanks for your help.