08 2019 档案

MSSQL随机修改时间
摘要：GO DECLARE @BDate datetime, @EDate datetime SET @BDate = '20190801' --上限 SET @EDate = '20190819 23:59:59' --下限 UPDATE [dbo].[Service] SET [Addtime] = DATEADD(second,ABS(CHECKSUM(NEWID()))%DATEDIFF(sec 阅读全文
posted @ 2019-08-19 13:48 懒人境界 阅读(288) 评论(0) 推荐(0)