Home Forums Article Discussions Article Discussions by Author Discuss content posted by Tom Thomson First Normal Form RE: First Normal Form

  • July 5, 2011 at 4:23 pm

    #1348646

    SQLkiwi (7/4/2011)

    James Goodwin (7/1/2011)

    It would be nice if there was a more clean SQL syntax than (X is NULL OR X <> 'Value'), but that is implementation, not theory.

    There is an alternative to that, which I use quite a lot:

    http://sqlblog.com/blogs/paul_white/archive/2011/06/22/undocumented-query-plans-equality-comparisons.aspx

    Nice blog post, Paul. Never thought of trying that route. One more trick in my bag, thanks!

    --------------------------------------------------------------------------
    A little knowledge is a dangerous thing (Alexander Pope)
    In order for us to help you as efficiently as possible, please read this before posting (courtesy of Jeff Moden)[/url]