THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » bad habits » date range queries   (RSS)
  • What do BETWEEN and the devil have in common?

    I'll make no bones about it: BETWEEN is evil. For one, the meaning of the word in English does not always match the meaning of the operator in T-SQL. In T-SQL, BETWEEN is an *inclusive* range - not everyone gets that. Sure, in casual conversation when someone says ''between 3 and 6'' the answer really could be 3, 4, 5 or 6; but other times, they ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 19, 2011
Privacy Statement