1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
| --CREATE 5 RANDOM ORDERS BY CUSTOMER ID 4, MONITOR FOR ALERTS IN SLACK.
WHILE (@I < 5)
BEGIN
SET @M = (SELECT ROUND(RAND() * 12, 0))
SET @D = (SELECT ROUND(RAND() * 28, 0))
SET @Y = (SELECT 2020)
SET @DT = (SELECT CAST(@M AS VARCHAR(2)) + '/' + CAST(@D AS VARCHAR(2)) + '/' + CAST(@Y AS VARCHAR(4)))
SET @AMT = (SELECT 1 + ROUND(RAND() * (600 + 1 - 1), 0))
INSERT INTO Orders
VALUES(@DT,@AMT,'Random',4)
SET @I = @I + 1
WAITFOR DELAY '00:00:05'
END
|