Delete all but top 100 rows

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Delete all but top 100 rows

Message

15/05/2014 10:27:34

Nicholas Mason
London, Royaume Uni

Tous

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Delete all but top 100 rows

Versions des environnements

SQL Server:

SQL Server 2008

Application:

Web

Divers

Thread ID:

01600029

Message ID:

01600029

Vues:

HI

Whats the easiest way to delete all but the top 100 rows from a table.

I'm testing somehting but I don't want to shove tens of thousands of records through it yet.

Thanks

Nick

Répondre

Fil

Voir

Click here to load this message in the networking platform