Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
.NULL. field
Message
De
10/04/2006 13:40:20
 
 
À
10/04/2006 13:32:52
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01112086
Message ID:
01112088
Vues:
13
>why when i insert in sql server the field that are empty write .null.

When you insert a record, any field you do not specify a value for will be inserted as whatever was specified as default in that field, or NULL if not. Unless the field (column) is specifically marked as NOT NULL whereas you will get an error saying that no nulls are accepted.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform