Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Setting default for almost all columns in a table?
Message
De
14/07/2012 02:46:21
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01548548
Message ID:
01548569
Vues:
48
>Hi,
>
>I am wondering (want to make sure I won't regret at some point) if setting default to many columns is ok (from the stand-point of good db design practice). For example, I have a table that has 34 columns and it looks like I will have defaults set for 30 columns (some 0, some empty string ''). Is this ok? TIA.

You decide whether you prefer the convenience of having a value set by SQL engine
or risk forget to enter a value in an INSERT without an error
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform