How to create date column automatically

Question

This is my code sir

 

create table demotable

(

Id int primary key identity(1,1),

Name varchar(50),

StartDate date,

EndDate date

)

declare @command nvarchar(max)

declare @dates int, @StartDate datetime, @EndDate datetime

---Here, we assume that,

Select @StartDate = convert(datetime, '1/7/2015'), @endDate = convert(datetime,'1/10/2015')

select @dates = datediff (dd,@StartDate ,@Enddate)

While (@dates >0) begin

set @command = 'alter table demotable add [1/7/2015' + cast(@dates as nvarchar(max)) + '] datetime'

exec sp_executesql @command

select @dates = @dates - 1

end

 

 

 

when i execute this am getting the output is

 Id    Name            StartDate    EndDate      1/7/20153       1/7/20152      1/7/20151

 

 

but i want date columns like 1/7/2015   1/8/2015   1/9/2015 

I want to increase date columns using start date and end date