有这个必要加上表A吗? 只要对表B的时间进行判断不就能直接得到是否空闲了吗?SELECT @Flag = CASE WHEN DATEPART(Hour,@Time) BETWEEN 13 and 14 THTN '空闲' ELSE '繁忙' END @Time为从A表中获得的时间
SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GOALTER TRIGGER [名称] ON [dbo].[B] FOR UPDATE,INSERT AS update A set 是否空闲 = 是 select B.会议开始时间,B.会议结束时间 from B, where 13:00 <= B.会议开始时间 <=14:00 and 13:00 <= B.会议结束时间 <=14:00GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO大概就是这样了 写得不太全 自己改改吧
只要对表B的时间进行判断不就能直接得到是否空闲了吗?SELECT @Flag =
CASE
WHEN DATEPART(Hour,@Time) BETWEEN 13 and 14 THTN '空闲'
ELSE '繁忙'
END
@Time为从A表中获得的时间
GO
SET ANSI_NULLS ON
GOALTER TRIGGER [名称] ON [dbo].[B]
FOR UPDATE,INSERT
AS
update A set 是否空闲 = 是
select B.会议开始时间,B.会议结束时间
from B,
where 13:00 <= B.会议开始时间 <=14:00
and 13:00 <= B.会议结束时间 <=14:00GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO大概就是这样了 写得不太全 自己改改吧