Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Steve Jones Coming In August RE: Coming In August

  • July 10, 2008 at 7:15 pm

    #841194

    Date and Time!! - They're finally separate so you can query as salesdate > '2008/07/09' instead of salesdate > '2008/07/09 00:00:00'.

    You can do that in all versions of SQL Server since 6.5... nothing new there.

    I, too, can't wait until the split of Date and Time... leaves much opportunity to easily get to 15,000 posts in a hurry explaining to people how to fix what they have unwittingly done by using the split. 😉

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)