Difference between = and

Question

What is the difference between >= and <= and between keyword in SQL server.Please give an example.

Sanjeeb Lenka · Answer

check this link http://stackoverflow.com/questions/1960801/why-use-the-between-operator-when-we-can-do-without-it http://stackoverflow.com/questions/921282/compare-performance-difference-of-t-sql-between-and-operator

Iftikar Hussain · Answer

Yes. You can look into the screen shot. Regards Iftikar

Ravi Shekhar · Answer

Hi Iftikar  Your example says that between is slower than =. am i right???

Iftikar Hussain · Answer

Hi ' >=' and ' are much faster then between keyword. The between will filter rows after reading all the records where as >= and using between using >= and Regards Iftikar

Jignesh Trivedi · Answer

hi Between keyword perform > and = and Note: for Between you have write single time expression where as = you have to write expression mutliple time. hope this will help you.

Difference between >= and <= and between keyword in SQL serv