WHERE: Using BETWEEN and NOT BETWEEN - view details
Another useful operator in SQL Server is BETWEEN. In this video Scott will cover the BETWEEN statement, and show you some real world examples of when you would use this statement.
Highlights from this video:Test for ranges
Collapsing a range using BETWEEN
inclusiveused for numerics and dates
and much more Source: http://www.learnitfirst.com/Course/160/Video/2261/Using-BETWEEN-and-NOT-BETWEEN.aspx Course: http://www.learnitfirst.com/Course/160/SQL-Queries-2008.aspx Skill Level: 200 (Beginner - Intermediate) Length: 04:15 (11.6MB) Full DetailsTo download this video, log in then then visit the video's detail page and click "download".
Keywords for this video: sql server, queries, between, range, inclusive, numerics, dates
This video comes from the SQL Server 2005/2008 Queries online training course, Writing Queries for SQL Server (2005/2008 Edition). And be sure to check out even more SQL Server 2008/2005 Query Writing training videos.
