Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove Line from table
Message
 
 
À
12/10/2005 15:17:58
Mazahir Naya
Kuwait United Co.
Kuwait, Kuwait
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Divers
Thread ID:
01058420
Message ID:
01058427
Vues:
20
>hi to All Experts
>i have one table & in this table i have somany records.
>my problem is there is some row is Dispaly "< Null >" value in all fields.
>so how to remove all this row.
>
DELETE FROM mytable 
  WHERE COALESCE(col1, col2, col3, ..., colN) IS NULL
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform