Missing Dates return as dataset

select * from tblDate where Tdate between '01/01/2014' and '31/10/2014'
select * from tblDate where Tdate between '2014-01-01' and '2014-10-31'
select * from tblDate where Tdate >='2014-01-01' and Tdate <='2014-10-31'

DECLARE @MinDate DATE =  CAST('20140101'  AS DATETIME),
        @MaxDate DATE =  CAST('20141031'  AS DATETIME);

SELECT  DateColumn
FROM    Table WHERE   DateColumn>= @MinDate
AND    DateColumn< @MaxDate;

select * from tablename where datefield between @fromdate and @todate

con.Open();
cmd=new SqlCommand("select * from tablename where datefield between @fromdate and @todate", con);
da=new SqlDataAdapter(cmd);
ds= new DataSet();
da.Fill(ds);

declare @startDate DATE = '2015-01-01'
declare  @endDate DATE = '2015-12-31'
;withMissingDates (date)
as
(
    select @startDate
    unionall
    select dateadd(month, 1, date)
    from MissingDates
    where dateadd(month, 1, date)<=@endDate
)
select yeaar(date) as Year, month(date) as Month
from MissingDates

except

select distinct year(MissingDates) as year, month(MissingDates) as month
from TableName
where  OrderId = 1 and MissingDates between @startDate and @endDate

http://www.xaprb.com/blog/2005/12/06/find-missing-numbers-in-a-sequence-with-sql/
http://stackoverflow.com/questions/28138536/sql-server-select-missing-months-between-2-dates-in-same-year

var fruits = ["Banana", "Orange", "Apple", "Mango"];
 fruits.push("Kiwi");