SQL : BETWEEN vs =

by

They are identical: BETWEEN is a shorthand for the longer syntax in the question that includes both values (EventDate >= '10/15/2009' and EventDate <= '10/19/2009').

Use an alternative longer syntax where BETWEEN doesn’t work because one or both of the values should not be included e.g.

Select EventId,EventName from EventMaster
where EventDate >= '10/15/2009' and EventDate < '10/19/2009'

(Note < rather than <= in second condition.)

More Related Contents:

  1. Calculate a Running Total in SQL Server
  2. How can I do an UPDATE statement with JOIN in SQL Server?
  3. Not equal != operator on NULL
  4. SET NOCOUNT ON usage
  5. How can I get column names from a table in SQL Server?
  6. How can I select the first day of a month in SQL?
  7. Subquery using Exists 1 or Exists *
  8. Most efficient T-SQL way to pad a varchar on the left to a certain length?
  9. Select statement to find duplicates on certain fields
  10. Is it possible to specify condition in Count()?
  11. Getting only Month and Year from SQL DATE
  12. TSQL PIVOT MULTIPLE COLUMNS
  13. When to use Common Table Expression (CTE)
  14. INT vs Unique-Identifier for ID field in database
  15. How to send email from SQL Server?
  16. How To Create Table with Identity Column
  17. Why do you create a View in a database?
  18. SQL query to find Nth highest salary from a salary table
  19. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  20. How to split string using delimiter char using T-SQL?
  21. Get the records of last month in SQL server
  22. Merge overlapping date intervals
  23. I want to use CASE statement to update some records in sql server 2005
  24. Access to Result sets from within Stored procedures Transact-SQL SQL Server
  25. alternatives to REPLACE on a text or ntext datatype
  26. SQL poor stored procedure execution plan performance – parameter sniffing
  27. How to return a incremental group number per group in SQL
  28. COALESCE Function in TSQL
  29. Convert bigint to datetime
  30. When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?

Leave a Comment