Forum Replies Created

Viewing 15 posts - 1 through 15 (of 31 total)

  • RE: Who Likes NULL?

    drew.allen - Monday, July 16, 2018 7:45 AM

    And when do the following

    SELECT *
    FROM Employee e
    LEFT OUTER JOIN Employee_Terminate et
       ...

  • RE: Who Likes NULL?

    roger.plowman - Friday, July 13, 2018 12:37 PM

    We're quibbling about semantics. Logical domains can and must be modeled physically with ill-matching...

  • RE: Who Likes NULL?

    drew.allen - Friday, July 13, 2018 12:49 PM

    Dennis Q Miller - Friday, July 13, 2018 12:30 PM

  • RE: Who Likes NULL?

    Matt Miller (4) - Thursday, July 12, 2018 2:16 PM

    Dennis Q Miller - Wednesday, July 11, 2018...

  • RE: Explicit Transactions

    Great explanation of transactions--an important topic with intricacies that every developer should understand.  I do think the article pertains equally well to implicit transactions, though, and could use a paragraph...

  • RE: Who Likes NULL?

    Lynn Pettis - Wednesday, July 11, 2018 9:27 AM

    Why would StartDate be NULL?  EndDate can be null since it may not...

  • RE: Who Likes NULL?

    roger.plowman - Wednesday, July 11, 2018 6:54 AM

    Null being a value or not is semantics. Null is a countable state, therefore...

  • RE: Who Likes NULL?

    Jeff Moden - Wednesday, July 11, 2018 8:28 AM

    Not sure how you think the first statement can never be true if...

  • RE: Who Likes NULL?

    Lynn Pettis - Tuesday, July 10, 2018 9:31 AM

    So, what is the difference between:
    StartDate >= '2018-01-01' AND EndDate IS...

  • RE: Who Likes NULL?

    roger.plowman - Tuesday, July 10, 2018 9:15 AM

    Because Null only gives you one value, a value that doesn't tell you why...

  • RE: Who Likes NULL?

    drew.allen - Tuesday, July 10, 2018 10:27 AM

    Codd discussed two different types of unknown values: Unknown but applicable and Unknown and...

  • RE: Who Likes NULL?

    edwardwill - Monday, July 9, 2018 6:34 AM

    Jeff Moden - Monday, July 9, 2018 6:29 AM

    July 9, 2018 at 2:23 pm

    #1996864

  • RE: Who Likes NULL?

    Romac - Friday, July 6, 2018 3:41 AM

    edwardwill - Friday, July 6, 2018 2:19 AM

    When...

  • RE: Who Likes NULL?

    edwardwill - Friday, July 6, 2018 1:17 PM

    I'm enjoying this topic but there's a world of difference between an academic discussion about...

  • RE: Auto-suggesting foreign keys and data model archaeology

    The purpose of constraints is to improve data integrity.  By "integrity" I mean accuracy, internal consistency, and faithful assertion of business requirements for which the database serves.

    So, I'm...

Viewing 15 posts - 1 through 15 (of 31 total)