小二来一只葫芦

--生成时间段的随机时间declare @date_start datetimedeclare @date_end datetimeset @date_start= '2020-05-01'set @date_end=getdate()select 时间 = dateadd(minute,abs(checksum(newid()))%(datediff(minute,@date_start,@date_end)+1),@date_start)...

sqlserver获取本月第一天和最后一天：SELECT DATEADD(MM,DATEDIFF(MM,0,GETDATE()),0),DATEADD(MS,-3,DATEADD(MM, DATEDIFF(m,0,GETDATE())+1, 0))