Information générale
Forum:
Microsoft SQL Server
>Eric.
>If the Key fields are Ints, is there a problem getting reliable result sets when zeroes are in the foreign key fields rather than Nulls? Are Nulls treated differently than Zeroes? If you don't allow Nulls in your foreign key field then zero would seem like the natural "empty" value for a link. We are having a debate on this right now. Programatically it seems easier to deal with Zeroes than Nulls, but SQL result sets don't seem as reliable. Any input you, or Sergey, or anyone else could give me would be greatly appreciated.
>
>Regards,
If the situation calls for it, use nulls. Like Mike said, its more like a relgious thing. Personally I use nulls here and there but, I have never had to use a null in a releationship.
Eric
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement