SQL Server记录轮班工作两方法(2)

列表A Rc>kxz( +  
DECLARE @StartTime VARCHAR(20)SET @StartTime ='15:35:25.000' n !^ )EWdh  
SELECT CASE      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'08:00:00'AND'15:59:59' THEN 'First Shift'      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'16:00:00'AND'23:59:59' THEN 'Second Shift'      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'00:00:00'AND'07:59:59' THEN 'Third Shift'      ELSE 'UNKNOWN'END AS Shift

列表A Rc>kxz( +  
DECLARE @StartTime VARCHAR(20)SET @StartTime ='15:35:25.000' n !^ )EWdh  
SELECT CASE      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'08:00:00'AND'15:59:59' THEN 'First Shift'      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'16:00:00'AND'23:59:59' THEN 'Second Shift'      WHEN CONVERT(DATETIME, @StartTime, 108)BETWEEN'00:00:00'AND'07:59:59' THEN 'Third Shift'      ELSE 'UNKNOWN'END AS Shift

列表C cI=i2xl8  
DECLARE @StartTime VARCHAR(20)SET @StartTime ='22:59:59' ; i /O4Uz  
SELECTTOP 1 ShiftName FROM ShiftWork.Shifts      WHERE @StartTime >= Shifts.StartTimeORDERBY StartTime DESCGO S v[_a  
DECLARE @StartTime VARCHAR(20)SET @StartTime ='01:59:59' c. NR c  
SELECTTOP 1 ShiftName FROM ShiftWork.Shifts      WHERE @StartTime >= Shifts.StartTimeORDERBY StartTime DESCGO > fO%0K?C  
DECLARE @StartTime VARCHAR(20)SET @StartTime ='12:59:59' /M,p Jd3t  
SELECTTOP 1 ShiftName FROM ShiftWork.Shifts      WHERE @StartTime >= Shifts.StartTimeORDERBY StartTime DESCGO