Posted by Hugo Kornelis on 08/17/07 22:44

On Fri, 17 Aug 2007 10:56:10 -0000, WhytheQ wrote:

>This comes up with nothing:
>'=====================
>USE myDatabase
>SELECT *
>FROM myTable
>TABLESAMPLE (1 ROWS)
>'====================
>
>...whereas this works:
>'=====================
>USE myDatabase
>SELECT *
>FROM myTable
>TABLESAMPLE (1 PERCENT)
>'====================
>
>Any ideas??

Hi J,

TABLESAMPLE won't give you the exact number of rows you asked for, but
an approximation. This is explained in Books Online (though not as
clearly as I hoped and thought it was).

Also see Erland's reply in your other thread.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

• Next in forum: Re: SELECT a random 10 records from table....easy newbie question
• Prev in forum: Re: SELECT a random 10 records from table....easy newbie question
• Thread view: Re: SELECT a random 10 records from table....easy newbie question

[Reply to this message]