How to create a script to populate a table of time intervals?

Question

SQL Server

Table TimeSlot; id, start time, end timeHow to make a script that will make 23/24 entries starttime - endtime0.00-1.00, 1.00-2.00, etc.

Answer 1

The corresponding columns are of type TIME.

DECLARE @I INT = 0
WHILE @I < 24 BEGIN
  INSERT [TimeSlot] ([Start Time], [End Time]) 
    VALUES ( CAST( DATEADD( hh, @I, 0 ) AS TIME ),  CAST( DATEADD( hh, @I + 1, 0 ) AS TIME ))
  SET @I = @I + 1
END