|
|
Posted by Sψren Reinke on 08/17/07 06:12
Hugo Kornelis wrote:
> On Thu, 16 Aug 2007 03:39:49 -0700, WhytheQ wrote:
>
>> This doesn't work:
>>
>> --****************************************
>> USE myDatabase
>> SELECT TOP 10 *
>>FROM myTable
>> WHERE NEWID()
>> --****************************************
>>
>> ..I know I need to use the function newID() to find random records -
>> just don't know where it fits in the query (suspect the TOP will need
>> to go from the above)
>>
>> Any help greatly appreciated
>> J
>
> Hi J,
>
> Marcin's answer is correct. However, if you're on SQL Server 2005 you
> can also use the new TABLESAMPLE option (see Books Online for the
> details); this will probably perform better on large tables.
Do you have a link to the book you are talking about ?
p.s. You blog is to large for pageflakes :( (max 512000 bytes) could you
maybe cut down the articles in the feed ?
Best regards
SΓΈren
Navigation:
[Reply to this message]
|