隨機產生日期

mhfo

DECLARE @SDate DATETIME, @EDate DATETIME;
SET @SDate = '2013/01/01';
SET @EDate = '2013/12/31';

SELECT DATEADD(day, RAND(CHECKSUM(NEWID())) * DATEDIFF(DAY, @SDate, @EDate), @SDate);