Getting 14 random records - Level Extreme

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Getting 14 random records

Message

De

12/11/2009 12:00:34

Naomi Nosonovsky
Wisconsin, États-Unis

À

22/07/2009 11:27:32

Naomi Nosonovsky
Wisconsin, États-Unis

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Re: Getting 14 random records

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01382524

Message ID:

01434416

Vues:

50

>See some test data
>
>http://forum.lessthandot.com/viewtopic.php?f=17&t=6798&p=34719#p34719
>
>they seem to confirm Roman's observation, so selecting just ID seem to be quicker.

See also this interesting article http://www.sqlmag.com/Articles/ArticleID/93966/93966.html

If it's not broken, fix it until it is.

My Blog

Click here to load this message in the networking platform