create trigger dining_time_ins on dining_time for insert
as
insert into dining_state
select card_id, dining_date, case
when datepart( hour, dining_hour ) between 1 and 9 then 1
else 0
end as breakfast, case
when datepart( hour, dining_hour ) between 10 and 15 then 1
else 0
end as lunch, case
when datepart( hour, dining_hour ) between 16 and 23 or datepart( hour, dining_hour ) = 0 then 1
else 0
end as supper
from inserted
as
insert into dining_state
select card_id, dining_date, case
when datepart( hour, dining_hour ) between 1 and 9 then 1
else 0
end as breakfast, case
when datepart( hour, dining_hour ) between 10 and 15 then 1
else 0
end as lunch, case
when datepart( hour, dining_hour ) between 16 and 23 or datepart( hour, dining_hour ) = 0 then 1
else 0
end as supper
from inserted
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货