In SQL sever 2008, when you use between the lower limit and the upper limit are inclusive in inclusive in the result.
create table #temp(
id int primary key identity,
name varchar(20)
)
insert into #temp values('a')
insert into #temp values('b')
insert into #temp values('c')
insert into #temp values('d')
insert into #temp values('e')
insert into #temp values('f')
select * from #temp where id between 2 and 4
Note the result. The above query will include record with id=3 but 2 and 4 also.
Output
+----+------+ | id | name | +----+------+ | 2 | b | | 3 | c | | 4 | d | +----+------+
