SQL Server记录轮班工作两方法

CREATESchema ShiftWork

GO


CREATETABLE ShiftWork.Shifts
      (
            StartTime Char(8)NOTNULLPRIMARYKEY,
            ShiftName Varchar(20)NOTNULL
      )
GO


INSERTINTO ShiftWork.Shifts
      (StartTime, ShiftName)
      VALUES
      ('08:00:00','First Shift')


INSERTINTO ShiftWork.Shifts
      (StartTime, ShiftName)
      VALUES
      ('16:00:00','Second Shift')


INSERTINTO ShiftWork.Shifts
      (StartTime, ShiftName)
      VALUES
      ('00:00:00','Third Shift')
GO