如何在表格中增加日期 [英] How to increase date in table

问题描述

Case when EXISTS(SELECT * FROM holiday_list WHERE [DAY] = @date AND [YEAR] = YEAR(@date)) then DATEADD(D,1,@Actual_Leave_To)

actullay这是我的情况holiday_list是我公共假期的表格在此表中显示假设假日日期是25/12/15并且我们执行此案例然后此日期添加并显示日期26/12/15



但我想要知道什么时候我宣布24/12/15然后它将显示26/12/15意味着它明白第二天是25/12/15这是公共假日在我的表和日期显示26/12/15





请帮助

actullay this is my case holiday_list is my table where public holiday show in this table suppose holiday date is 25/12/15 and we execute this case then this date add and show date 26/12/15

but i want to know when i declare 24/12/15 then it will show 26/12/15 means it understand next day is 25/12/15 this is public holiday which is in my table and date show 26/12/15


please helpme

推荐答案

while循环用于处理连续公众假期的情况

while loop is implemented to handle the case of consecutive public holidays

create table #holiday_list (hol_date date, hol_desc varchar(100))
insert into #holiday_list
values('12/25/2015', 'Christmasc Day')

declare @Actual_Leave_To date
set @Actual_Leave_To='12/25/2015'

while(select count(1) from #holiday_list where hol_date = @Actual_Leave_To)>0
begin
	set @Actual_Leave_To = DATEADD(d,1,@Actual_Leave_To)
end  
select @Actual_Leave_To
drop table #holiday_list

create table #holiday_list (hol_date date, hol_desc varchar(100))
insert into #holiday_list
values('12/25/2015', 'Christmasc Day')
 
declare @Actual_Leave_To date, @Next_Day date
set @Actual_Leave_To='12/24/2015'
set  @Next_Day=dateadd(d,1,@Actual_Leave_To)
 
while(select count(1) from #holiday_list where hol_date = @Next_Day)>0
begin
    set @Next_Day = DATEADD(d,1,@Next_Day)
end  
select @Next_Day
drop table #holiday_list

为什么你不这样做：





UPDATE holiday_list

SET D = DATEADD（D，1，@ Actual_Leave_To）

其中ID在（SELECT ID FROM） holiday_list WHERE [DAY] = @date AND [YEAR] = YEAR（@date））

Why don't you just do it something like this:


UPDATE holiday_list
SET D = DATEADD(D,1,@Actual_Leave_To)
where ID in (SELECT ID FROM holiday_list WHERE [DAY] = @date AND [YEAR] = YEAR(@date))

这篇关于如何在表格中增加日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！