Why should I use SQL Server's BETWEEN ... AND syntax?
Posted
by Jeff Meatball Yang
on Stack Overflow
See other posts from Stack Overflow
or by Jeff Meatball Yang
Published on 2010-04-22T16:19:20Z
Indexed on
2010/04/22
16:23 UTC
Read the original article
Hit count: 177
Filed under:
sql-server
|Performance
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?
© Stack Overflow or respective owner
