Randomly generate the date of the specified range

In MSSQL, some products may forge some comments, but the evaluation information may be concentrated in one day or several days. Now we need to scatter the date, and the average score is less than one date segment, this code is useful. No DECLARE @ EvIdINT, @ PiDINT; DECLAREEvaluateCURSORFORSELECTEvaluateId, ProductIdFROMdbo. Produ

In MSSQL, some products may forge some comments, but the evaluation information may be concentrated in one day or several days. Now we need to scatter the date, and the average score is less than one date segment, this code is useful. No DECLARE @ EvId INT, @ PiD INT; DECLARE Evaluate cursor for select EvaluateId, ProductId FROM dbo. Produ

In MSSQL, some products may forge some comments, but the evaluation information may be concentrated in one day or several days. Now we need to scatter the date, and the average score is less than one date segment, this code is useful. <无>

DECLARE @ EvId INT, @ PiD INT; DECLARE Evaluate cursor for select EvaluateId, ProductId FROM dbo. productEvaluate WHERE CreateTime> '2017-10-20 00:00:01 '; OPEN Evaluate; fetch next from Evaluate INTO @ EvId, @ PiD; WHILE @ FETCH_STATUS = 0 BEGINDECLARE @ BDate datetime, @ EDate DATETIME, @ PDate DATETIME; SET @ BDate = '000000' -- lower limit SELECT @ BDate = CONVERT (varchar (20140101), CreateTime, 100) FROM dbo. products WHERE ProductId = @ PiD; SET @ EDate = '2014 23:59:59 '-- upper limit of UPDATE dbo. productEvaluate SET CreateTime = DATEADD (second, ABS (CHECKSUM (NEWID () % DATEDIFF (second, @ BDate, @ Edate), @ BDate) WHERE EvaluateId = @ EvId; fetch next from Evaluate INTO @ EvId, @ PiD; ENDCLOSE Evaluate; DEALLOCATE Evaluate;