Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Select random records
Message
From
22/04/2004 12:15:41
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, United States
 
 
To
22/04/2004 12:07:01
Fabio Lunardon
Lunacom
Marostica, Italy
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: Select random records
Miscellaneous
Thread ID:
00897233
Message ID:
00897257
Views:
14
What a surprise! I'd have never thought of that. It works...

Thanks,
Guy


>MS SQL standard random select is:
>
>SELECT TOP 500 * FROM TABLE ORDER BY NEWID()
>
Previous
Reply
Map
View

Click here to load this message in the networking platform