2024-01-29

DECLARE @Count INT = 0;
DECLARE @RandomDateTime DATETIME;
DECLARE @StartDate DATETIME = '2023-01-01';
DECLARE @EndDate DATETIME = '2023-02-01';

WHILE @Count < 8040
BEGIN
    -- Generate a random datetime in January 2023
    SELECT @RandomDateTime = DATEADD(MINUTE, (ABS(CHECKSUM(NEWID())) % 44640), @StartDate);

    -- Insert a row into W_log
    INSERT INTO W_log (ip, time, url) VALUES ('172.16.13.163', @RandomDateTime, NULL);

    SET @Count = @Count + 1;
END

| 1 | 8040 |
| 2 | 19360 |
| 3 | 4939 |
| 4 | 4229 |
| 5 | 4266 |
| 6 | 7076 |
| 7 | 12203 |
| 8 | 10045 |
| 9 | 6772 |
| 10 | 14229 |
| 11 | 3244 |
| 12 | 6794 |
| 和 | 101197 |

101197