Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Null
Message
 
À
04/06/2009 12:33:21
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Titre:
Re: Null
Versions des environnements
SQL Server:
SQL Server 2005
Divers
Thread ID:
01403676
Message ID:
01403723
Vues:
41
>>For what it's worth, I only use NULLs (when I have a say in the matter) when NULL has business significance (i.e. a user left a survey question or some other column blank).
>>
>>If there is no business need to differentiate between a NULL and an empty string, my personal vote is for empty string.
>
>Sorry, I may be misunderstanding, but "(i.e. a user left a survey question or some other column blank)" seems to contrast with "If there is no business need to differentiate between a NULL and an empty string, my personal vote is for empty string". Unless you consider the user leaving a survey question blank as a business need. Was the field required or optional? If it was optional, it makes sense to leave it blank. If it was required and not filled out (and validation let it pass) then it makes sense to make it NULL because there's a business need to act on that later.
>
>Are we saying the same thing but in different ways?

It sounds that way to me..
____________________________________

Don't Tread on Me

Overthrow the federal government NOW!
____________________________________
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform