declare @year int
declare @month int

select @year = 2008, @month = 2

select
	*
from
	MyTable
where
	-- Date on or after start of year
	MyTable.MyDate >= dateadd(month,(12*@Year)-22801+1,0)	and
	-- Date before start of next month
	MyTable.MyDate <  dateadd(month,(12*@Year)-22801+@Month+1,0)

declare @year smallint,
        @month tinyint

set @year = 2007
set @month = 2

select
    sum(Amount)
from
    dbo.myEntries
where
    myEntries.myDate >= dateadd(yy,(@year - 1900), 0)
    and myEntries.myDate < dateadd(mm, @month, dateadd(yy,(@year - 1900), 0))

  WHERE somedatecol >= @StartDate
    AND somedatecol < @EndDate+1

  WHERE somedatecol BETWEEN @StartDate AND DATEADD(ms,-3,@EndDate+1)
  WHERE somedatecol BETWEEN @StartDate AND @EndDate+'23:59:59.997