Link to home
Start Free TrialLog in
Avatar of enrique_aeo
enrique_aeo

asked on

sql server 2008 BETWEEN uses the same logic as >= AND <=

hi experts

this: BETWEEN uses the same logic as >= AND <=
is it true or false?
can you explain me with transact sql code?
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of enrique_aeo
enrique_aeo

ASKER

please, can you give me the URL this download AdventureWorks2012 database
You can download a trial version here:
http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx

You should also be able to take the T-SQL you have provided, copy-paste it into the SSMS of any version of SQL server, modify to work with any table, and see for yourself.
I refer to this database: AdventureWorks2012
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial