如何识别特定的人在SQL QUERY中的特定时间段？ [英] How to identify wheather particular person is engaged in particular time slot in SQL QUERY?

问题描述

我在sql中有一个表

 日期日期开始时间 结束 时间主题教师
 2014-06-02星期一下午2:30 PM 04:30 PM数学Mr.Smith 
 2014-06-10星期二下午2:30 PM 04:30 PM科学Mr.Ayar 
 2014-06-16星期一下午2:30 PM 04:30 PM数学Mr.Smith 
  2014-06-02星期一下午3:30 PM 04:30 PM数学Mr.Smith插入新行 

我想查询Mr.Smith已经参与了插入的时段

解决方案

< blockquote>如果您的时间段的开头或结尾处于（特定日期）开始时间和结束时间之间，则该人员已经参与。这不是一个难以写的查询。

会员10272815 ....我希望下面的查询将澄清你的重叠。

  SELECT  COUNT（ 1 ） FROM  Your_Table（ NOLOCK ） WHERE  teacher = '  Mr.Smith' 和 Day = '  Monday' 
  AND  [Start 时间]  BETWEEN  ' 您的开始时间'  AND  ' 您的结束时间' 或 [ END  时间]  BETWEEN  ' 您的开始时间'  AND  ' < span class =code-string>你的结束时间' 

你好，



在插入新记录之前进行检查。如果它返回的输出数超过了指定条件的记录，则其他情况不可用。



查询查询如下



SELECT COUNT（1）FROM Your_Table （NOLOCK）WHERE老师='Mr.Smith'和Day ='星期一'

AND [i> '你的开始时间' 在[开始时间]和[结束时间]之间





希望这对你有帮助。

I Have one table in sql

Date            Day     Start Time  End Time  Subject   Teacher
2014-06-02	Monday	2:30 PM	    04:30 PM  Maths	Mr.Smith
2014-06-10	Tuesday	2:30 PM	    04:30 PM  Science   Mr.Ayar
2014-06-16	Monday	2:30 PM	    04:30 PM  Maths	Mr.Smith
2014-06-02	Monday	3:30 PM	    04:30 PM  Maths	Mr.Smith Inserted New Row

I want to make query to check Mr.Smith is already engaged in inserted time slot

解决方案

If either the begin or the end of your time slot is between (that particular day) 'Start Time' and 'End Time' then that person is already engaged. It is not a difficult query to write.

Member 10272815....i hope below query will clarify your raised overlap.

SELECT COUNT(1) FROM Your_Table (NOLOCK) WHERE teacher = 'Mr.Smith' And Day = 'Monday'
AND [Start Time] BETWEEN 'Your Start Time' AND 'Your End Time' OR [END Time] BETWEEN 'Your Start Time' AND 'Your End Time'

Hi,

Put a check before inserting a new record. If it returns more than 0 output than record for specified criteria is available else not.

Check query is below

SELECT COUNT(1) FROM Your_Table (NOLOCK) WHERE teacher = 'Mr.Smith' And Day = 'Monday'
AND 'Your Start Time' BETWEEN [Start Time] AND [END TIME]


Hope this will help you.

这篇关于如何识别特定的人在SQL QUERY中的特定时间段？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！