tag:blogger.com,1999:blog-5070731366789101952.post708367563948608464..comments2023-10-30T02:07:59.792-07:00Comments on SQL Stuff: T-SQL: Why have NULL bit fields?_RichardABrownhttp://www.blogger.com/profile/12901630949273644048noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-5070731366789101952.post-89544726014891441172011-11-07T03:03:38.873-08:002011-11-07T03:03:38.873-08:00As i mentioned in my post, this is a contrived exa...As i mentioned in my post, this is a contrived example and this isn't a discussion about good database design nor whether NULLs are good (or evil). It was merely illustrating a scenario when a NULL bit field could be relevant._RichardABrownhttps://www.blogger.com/profile/12901630949273644048noreply@blogger.comtag:blogger.com,1999:blog-5070731366789101952.post-22048434074310751022011-11-04T04:48:28.852-07:002011-11-04T04:48:28.852-07:00That is my point - we have missed a domain concept...That is my point - we have missed a domain concept, namely that a job application progresses through various states. Once we have the correct domain concepts then the need for null disappears.Akashhttps://www.blogger.com/profile/02651035232871947798noreply@blogger.comtag:blogger.com,1999:blog-5070731366789101952.post-82017390880278620082011-11-03T06:53:48.227-07:002011-11-03T06:53:48.227-07:00The field isn't Status though, its Successful ...The field isn't Status though, its Successful which is either true or false or (as yet) undecided._RichardABrownhttps://www.blogger.com/profile/12901630949273644048noreply@blogger.comtag:blogger.com,1999:blog-5070731366789101952.post-81402820357490405672011-11-03T06:17:39.736-07:002011-11-03T06:17:39.736-07:00Nulls are evil. Didn't your mother teach to st...<a href="http://blogs.msdn.com/b/mattwar/archive/2005/06/01/424042.aspx" rel="nofollow">Nulls are evil</a>. Didn't your mother teach to stay away from them? :)<br /><br />In your example you are describing a value that has 3 possible states - "In progress", "Accepted" or "Rejected". There is nothing unknown.Akashhttps://www.blogger.com/profile/02651035232871947798noreply@blogger.com