Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To NULL or not to NULL
Message
From
16/01/2005 22:03:02
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00977538
Message ID:
00977650
Views:
31
>Why?<

Kevin,

Simply put, it means that the user did not enter any data for that column. A NULL is the only way to represent that. Not spaces, not zeroes. Good enough reason? <s>

~~Bonnie


>
>>Kevin,
>>
>>We allow NULLs for everything except for PKs and for the FK in a child table.
>>
>>~~Bonnie
Bonnie Berent DeWitt
NET/C# MVP since 2003

http://geek-goddess-bonnie.blogspot.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform