Why should I use SQL Server's BETWEEN ... AND syntax?
- by Jeff Meatball Yang
These two statements are logically equivalent:
select * from Table where someColumn between 1 and 100
select * from Table where someColumn >= 1 and someColumn <= 100
Is there a potential performance benefit to one versus the other?