mssql 달력 쿼리

날짜, 년, 월, 일, 요일

create table CALENDAR(VDATE varchar(10),VYEAR varchar(4),VMONTH varchar(2),VDAY varchar(2), VDAYK varchar(2))
 

declare @s_date varchar(10),@e_date varchar(10)
select @s_date ='2010-01-01',@e_date = '2020-12-31'
 
while @s_date <= @e_date
begin
           insert CALENDAR values(@s_date,left(@s_date,4),substring(@s_date,6,2),right(@s_date,2),left(datename(dw,convert(datetime, @s_date)),1))
           set @s_date = convert(varchar(10),dateadd(d,1,@s_date),121)
end
 
select * from CALENDAR