Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Get the total number of rows
Message
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Get the total number of rows
Divers
Thread ID:
00643239
Message ID:
00643239
Vues:
41
Is there a way to get the total number of rows without doing a select *.

I am do a import/export routine and want to make sure the table I am importing into does not have any existing data. Since I am walking down an array filled from SQLTABLE(gnConn), I don't know what the field names are to select just one field to count, and a count(*) would seem to be overkill.

Thanks in advance

Kirk
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform