i am trying to list of dates between two dates.
i had tried everything, but still didn't work out.

examples : start date = 01/12/2006 (in dd/mm/yyyy format)
end date = 06/12/2006

so the output should be


01/12/2006
02/12/2006
03/12/2006
04/12/2006
05/12/2006
06/12/2006


this the query in oracle
select to_date(:start_date,'dd-mon-yyyy') + rownum -1
2 from all_objects
3 where rownum <=
to_date(:end_date,'dd-mon-yyyy')-to_date(:start_date,'dd-mon-yyyy')+1

so,please anybody who knows the statement in ms sql..help me..